Drizzle-kit keeps recreating foreign key constraints

Every time I run drizzle-kit push, it drops and recreates my foreign key constraints
wilson@Wilsons-MacBook-Pro joeldim % pnpm exec drizzle-kit push
No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/wilson/Developer/Projects/joeldim/drizzle.config.ts'
Using 'postgres' driver for database querying
[✓] Pulling schema from database...

Warning You are about to execute current statements:

ALTER TABLE "session" DROP CONSTRAINT "session_user_id_user_id_fk";

ALTER TABLE "invoice_line_items" DROP CONSTRAINT "invoice_line_items_invoice_id_fk";

ALTER TABLE "payments" DROP CONSTRAINT "payments_customer_id_customers_id_fk";

ALTER TABLE "payments" DROP CONSTRAINT "payments_invoice_id_invoices_id_fk";

ALTER TABLE "account" DROP CONSTRAINT "account_user_id_user_id_fk";

ALTER TABLE "invoices" DROP CONSTRAINT "invoices_customer_id_customers_id_fk";

ALTER TABLE "session" ADD CONSTRAINT "session_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "invoice_line_items" ADD CONSTRAINT "invoice_line_items_invoice_id_fk" FOREIGN KEY ("invoice_id") REFERENCES "public"."invoices"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "payments" ADD CONSTRAINT "payments_customer_id_customers_id_fk" FOREIGN KEY ("customer_id") REFERENCES "public"."customers"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "payments" ADD CONSTRAINT "payments_invoice_id_invoices_id_fk" FOREIGN KEY ("invoice_id") REFERENCES "public"."invoices"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "account" ADD CONSTRAINT "account_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "invoices" ADD CONSTRAINT "invoices_customer_id_customers_id_fk" FOREIGN KEY ("customer_id") REFERENCES "public"."customers"("id") ON DELETE cascade ON UPDATE no action;
wilson@Wilsons-MacBook-Pro joeldim % pnpm exec drizzle-kit push
No config path provided, using default 'drizzle.config.ts'
Reading config file '/Users/wilson/Developer/Projects/joeldim/drizzle.config.ts'
Using 'postgres' driver for database querying
[✓] Pulling schema from database...

Warning You are about to execute current statements:

ALTER TABLE "session" DROP CONSTRAINT "session_user_id_user_id_fk";

ALTER TABLE "invoice_line_items" DROP CONSTRAINT "invoice_line_items_invoice_id_fk";

ALTER TABLE "payments" DROP CONSTRAINT "payments_customer_id_customers_id_fk";

ALTER TABLE "payments" DROP CONSTRAINT "payments_invoice_id_invoices_id_fk";

ALTER TABLE "account" DROP CONSTRAINT "account_user_id_user_id_fk";

ALTER TABLE "invoices" DROP CONSTRAINT "invoices_customer_id_customers_id_fk";

ALTER TABLE "session" ADD CONSTRAINT "session_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "invoice_line_items" ADD CONSTRAINT "invoice_line_items_invoice_id_fk" FOREIGN KEY ("invoice_id") REFERENCES "public"."invoices"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "payments" ADD CONSTRAINT "payments_customer_id_customers_id_fk" FOREIGN KEY ("customer_id") REFERENCES "public"."customers"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "payments" ADD CONSTRAINT "payments_invoice_id_invoices_id_fk" FOREIGN KEY ("invoice_id") REFERENCES "public"."invoices"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "account" ADD CONSTRAINT "account_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE cascade ON UPDATE no action;
ALTER TABLE "invoices" ADD CONSTRAINT "invoices_customer_id_customers_id_fk" FOREIGN KEY ("customer_id") REFERENCES "public"."customers"("id") ON DELETE cascade ON UPDATE no action;
Schema attached
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?