© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•16mo ago•
6 replies
desert.elf

drizzle-kit push keeps trying to drop and recreate the same constraints

                     │ALTER TABLE "authenticator" DROP CONSTRAINT authenticator_userId_credentialID_pk;
                     │--> statement-breakpoint
                     │ALTER TABLE "authenticator" ADD CONSTRAINT authenticator_userId_credentialID_pk PRIMARY KEY(userId,credentialID);
                     │ALTER TABLE "account" DROP CONSTRAINT account_provider_providerAccountId_userId_pk;
                     │--> statement-breakpoint
                     │ALTER TABLE "account" ADD CONSTRAINT account_provider_providerAccountId_userId_pk PRIMARY KEY(provider,providerAccountId,userId);
                     │ALTER TABLE "authenticator" DROP CONSTRAINT authenticator_userId_credentialID_pk;
                     │--> statement-breakpoint
                     │ALTER TABLE "authenticator" ADD CONSTRAINT authenticator_userId_credentialID_pk PRIMARY KEY(userId,credentialID);
                     │ALTER TABLE "account" DROP CONSTRAINT account_provider_providerAccountId_userId_pk;
                     │--> statement-breakpoint
                     │ALTER TABLE "account" ADD CONSTRAINT account_provider_providerAccountId_userId_pk PRIMARY KEY(provider,providerAccountId,userId);


drizzle-kit@0.26.2
using vercel-neon postgres

I see many posts with this happening but no responses. Any clues ? This is becoming a huge headache in production for us.
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Drizzle-kit keeps recreating foreign key constraints
Drizzle TeamDTDrizzle Team / help
8mo ago
How to drop a failed drizzle-kit push?
Drizzle TeamDTDrizzle Team / help
2y ago
drizzle-kit drop
Drizzle TeamDTDrizzle Team / help
7mo ago
drizzle-kit push
Drizzle TeamDTDrizzle Team / help
5mo ago