desert.elf Posts - Answer Overflow

desert.elf

Explore posts from servers

RRailway TTCTheo's Typesafe Cult DTDrizzle Team

•Created by desert.elf on 10/31/2024 in #help

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.

2 replies

Gaming

Programming