DT

Drizzle Team•3y ago

Adamgreg

Deferrable foreign key constraints

Hi, does anyone know a way to declare deferrable foreign key constraints when defining a Postgres table using pgTablepgTable, and a way to issue SET CONSTRAINTSSET CONSTRAINTS within a transaction when querying in Drizzle? Thanks!

https://www.postgresql.org/docs/current/sql-set-constraints.html

PostgreSQL Documentation

SET CONSTRAINTS

SET CONSTRAINTS SET CONSTRAINTS — set constraint check timing for the current transaction Synopsis SET CONSTRAINTS { ALL | name …