[FEATURE]: postgres: deferrable constraints

[ari-becker]

Describe what you want

https://www.postgresql.org/docs/16/sql-createtable.html#SQL-CREATETABLE-PARMS-DEFERRABLE

I'm looking for something along the lines of:

export const foo = pgTable("foo",
  {
    name: text("name").notNull(),
  },
  (foo) => ({
    uniqueName: unique("name_unique", {deferrable: true, initially: "immediate"}).on(foo.name),
  }),
) satisfies PgTable;

[edgars-sirokovs]

Also, currently drizzle-kit generate:pg is generating a new migration to DROP the CONSTRAINTs and re-CREATE them without the DEFERRABLE in case they are actually marked as deferrable in the DB. Should I register a bug for that?

[binnodon]

Would this feature include DEFERRABLE on ALL constraints? I'm especially looking for deferrable foreign key constraints.

[SiNONiMiTY]

Bumping this issue, this is achievable in the schema instead of manually editing the generated SQL files

[qimmer]

Bumping, same issue here.