Adamgreg
Explore posts from serversDTDrizzle Team
•Created by Adamgreg on 9/14/2023 in #help
Prepare raw sql query (Postgres)
Hi, I need to do a recursive query, so I think I need to use the magic sql operator to build it. Is it possible to make a prepared statement this way? I haven't been able to find a way, but something like
db.prepare(sql`...`)
would make sense to me.1 replies
DTDrizzle Team
•Created by Adamgreg on 9/2/2023 in #help
Deferrable foreign key constraints
Hi, does anyone know a way to declare deferrable foreign key constraints when defining a Postgres table using
pgTable
, and a way to issue SET CONSTRAINTS
within a transaction when querying in Drizzle? Thanks!
https://www.postgresql.org/docs/current/sql-set-constraints.html3 replies