Drizzle Team•5mo ago

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);

[email protected] 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.

5 Replies