Optio1 Comments - Answer Overflow

Optio1

Posts Comments

DTDrizzle Team

•Created by MaveriX89 on 1/8/2025 in #help

drizzle-kit push not working with pgSchema

😂 whatever works works. Thanks for figuring it out.

8 replies

DTDrizzle Team

•Created by MaveriX89 on 1/8/2025 in #help

drizzle-kit push not working with pgSchema

Can confirm this worked for me as well. Curious where you found that, would be worth updating the docs to have a link to that.

8 replies

DTDrizzle Team

•Created by MaveriX89 on 1/8/2025 in #help

drizzle-kit push not working with pgSchema

So I just changed my tables from pgTable(tableDefinition) to

export const customSchema = pgSchema('custom');
customshema.table(tableDefinition)

export const customSchema = pgSchema('custom');
customshema.table(tableDefinition)

and am experiencing the same issue. I found this issue with no known workaround. https://github.com/drizzle-team/drizzle-orm/issues/3476

8 replies

DTDrizzle Team

•Created by MaveriX89 on 1/8/2025 in #help

drizzle-kit push not working with pgSchema

Not sure why the auth schema isnt showing up, but for me, I had huge issues with postgres and drizzlekit push when defining things inside of an object inside a list. I would change

},
  (table) => [
    {
      checkConstraint: check("password_check", sql`char_length(${table.password}) >= 8`),
    },
  ],
);

},
  (table) => [
    {
      checkConstraint: check("password_check", sql`char_length(${table.password}) >= 8`),
    },
  ],
);

},
  (table) => [
      checkConstraint: check("password_check", sql`char_length(${table.password}) >= 8`),
  ],
);

},
  (table) => [
      checkConstraint: check("password_check", sql`char_length(${table.password}) >= 8`),
  ],
);

this resolved quite a few issues for me. For reference this is the github issue for this https://github.com/drizzle-team/drizzle-orm/issues/3596

8 replies

DTDrizzle Team

•Created by jack on 12/21/2024 in #help

[postgres] composite key does not result in constraint creation

I also agree, I hit this same issue. Definitely feels like a bug considering code verbatim from the docs does not work. Scape's fix above does work, simply removing the object inside of the array and passing the primaryKey straight through the array. The github issue linked above was closed and it is now being tracked here. https://github.com/drizzle-team/drizzle-orm/issues/3596

7 replies

Gaming

Programming