You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ALTERTABLE"course_orders" DROP CONSTRAINT"course_orders_signatory_id_user_infos_id_fk";
--> statement-breakpointALTERTABLE"orders" DROP CONSTRAINT"orders_requester_id_user_infos_id_fk";
--> statement-breakpointALTERTABLE"prestation_tags" DROP CONSTRAINT"prestation_tags_prestation_id_prestations_id_fk";
--> statement-breakpoint
DO $$ BEGINALTERTABLE"course_orders" ADD CONSTRAINT"course_orders_signatory_id_user_infos_id_fk"FOREIGN KEY ("signatory_id") REFERENCES"user_infos"("id") ON DELETE cascadeONUPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGINALTERTABLE"orders" ADD CONSTRAINT"orders_requester_id_user_infos_id_fk"FOREIGN KEY ("requester_id") REFERENCES"user_infos"("id") ON DELETE cascadeONUPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGINALTERTABLE"prestation_tags" ADD CONSTRAINT"prestation_tags_prestation_id_prestations_id_fk"FOREIGN KEY ("prestation_id") REFERENCES"prestations"("id") ON DELETE cascadeONUPDATE no action;
EXCEPTION
WHEN duplicate_object THEN null;
END $$;
Expected behavior
All the constraints are added in the migration (Missing constraints on companyInfo + prestationId
Environment & setup
Mac OS
Node: v20.11.0
Supabase database (Postgres)
Driver: pg: "^8.11.5"
The text was updated successfully, but these errors were encountered:
we've checked locally and it works as expected, we think it's related to your drizzle.config.ts file and seems like schema path does not include b/server/database/schemas/prestations.ts file
if you can provide a minimal repro example - would be perfect
What version of
drizzle-orm
are you using?0.30.10
What version of
drizzle-kit
are you using?0.20.18
Describe the Bug
When adding multiple constraints on a table, only the first one is generated in the migration:
Diff:
Migration generated:
Expected behavior
All the constraints are added in the migration (Missing constraints on
companyInfo
+prestationId
Environment & setup
Mac OS
Node: v20.11.0
Supabase database (Postgres)
Driver: pg: "^8.11.5"
The text was updated successfully, but these errors were encountered: