DT
Drizzle Team•4mo ago
Derock

SQLite: set fk constraint to be "DEFERRABLE INITIALLY DEFERRED"

I would like to use this feature of sqlite, but I don't see it mentioned anywhere in the docs. A quick search shows that there's an open issue (#1429) but no progress has been made. Are there any temporary workarounds to this? Like can I add in my own SQL to the end of a column definition?
1 Reply
Derock
Derock•3mo ago
Want results from more Discord servers?
Add your server
More Posts
Drizzle wants to truncate my tables when not neededI have this schema: ```ts export const users = sqliteTable('users', { id: text('id').notNull().pran npm run db:studio fine but localhost is still loading....SQLean's uuid4() in SQLite CREATE TABLEI'm using Turso, enabled SQLean uuid extension and I would like to generate a table via drizzle-kit How can we specify COLLATE on the schema?There is a feature request here: https://github.com/drizzle-team/drizzle-orm/issues/638 For adding Drizzle pg client throwing `scanner_yyerror` on pushGetting the following error upon running `drizzle-kit push:pg` to my local postgres. Drizzle-Kit verDrizzleError: Rollback is being rethrown unexpectedlyNo matter which error I throw for the rollback - it doesn't work as indented because it bleeds outsi