Adamgreg
Adamgreg
Explore posts from servers
DTDrizzle 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.html
3 replies