Conditional NotNull Column?
I have a 'users' table. User can have both phone number or email, or either, but both fields can't be null.
I tried adding the following constraint to my table:
But running into this issue on insert:
https://github.com/drizzle-team/drizzle-orm/issues/2694
Is there a better way to do this?
I tried adding the following constraint to my table:
sql "CHECK (email IS NOT NULL OR phone_number IS NOT NULL)"But running into this issue on insert:
https://github.com/drizzle-team/drizzle-orm/issues/2694
Is there a better way to do this?
GitHub![[BUG]: Nullable columns do not exist in insert(table).values() · I...](https://images-ext-1.discordapp.net/external/Y7i7_-T1FAPLuR4kFfgQ7yORqdfZd97DXspjUgDAvAk/https/opengraph.githubassets.com/5291f2269291c37c8c676dc277e897c4e0049e52616d28264fae76fe10414b5c/drizzle-team/drizzle-orm/issues/2694)
What version of drizzle-orm are you using? 0.32.1 What version of drizzle-kit are you using? 0.23.0 Describe the Bug const files = pgTable("files", { id: uuid("id").primaryKey()...
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
