16 replies

Unable to generate uuid as primary key

Hey everyone! I've searched through the help posts with similar titles but I could not get the answer I wanted. I have a prisma current setup, and trying to switch over, but my uuid is generated as my postgres primary key but I keep getting the following error:

"null value in column \"id\" of relation \"User\" violates not-null constraint"

"null value in column \"id\" of relation \"User\" violates not-null constraint"

I've tried all of the following:

export const patient = pgTable('User', {
  id: uuid('id')
    .default(sql`uuid_generate_v7()`)
    .primaryKey()
    .defaultRandom()

export const patient = pgTable('User', {
  id: uuid('id')
    .default(sql`uuid_generate_v7()`)
    .primaryKey()
    .defaultRandom()

  id: uuid('id').defaultRandom().primaryKey(),

  id: uuid('id').defaultRandom().primaryKey(),

and even the migration introspection tool set my id as this:

  id: text('id').primaryKey().notNull(),

  id: text('id').primaryKey().notNull(),

which definitely didnt work. Any ideas?

Drizzle Team•3y ago•

16 replies

imoby

Unable to generate uuid as primary key

"null value in column \"id\" of relation \"User\" violates not-null constraint"

"null value in column \"id\" of relation \"User\" violates not-null constraint"

I've tried all of the following:

export const patient = pgTable('User', {
  id: uuid('id')
    .default(sql`uuid_generate_v7()`)
    .primaryKey()
    .defaultRandom()

export const patient = pgTable('User', {
  id: uuid('id')
    .default(sql`uuid_generate_v7()`)
    .primaryKey()
    .defaultRandom()

  id: uuid('id').defaultRandom().primaryKey(),

  id: uuid('id').defaultRandom().primaryKey(),

and even the migration introspection tool set my id as this:

  id: text('id').primaryKey().notNull(),

  id: text('id').primaryKey().notNull(),

which definitely didnt work. Any ideas?

Unable to generate uuid as primary key

Similar Threads

Unable to generate uuid as primary key

Similar Threads

Similar Threads

Similar Threads