error: type "userrole[]" does not exist

So when I'm running db:push I'm getting an error that the enum userrole doesnt exist. I have the enum here and it shows in the supabase enums list as well.

This is the code

enum
export const userRole = pgEnum("UserRole", ["ADMIN", "TEACHER", "DEVELOPER", "STUDENT", "ALUMNI", "GUEST"]);

table attr
roles: userRole("roles")
      .array()
      .default(sql`ARRAY['STUDENT']::UserRole[]`)
      .notNull()

enum
export const userRole = pgEnum("UserRole", ["ADMIN", "TEACHER", "DEVELOPER", "STUDENT", "ALUMNI", "GUEST"]);

table attr
roles: userRole("roles")
      .array()
      .default(sql`ARRAY['STUDENT']::UserRole[]`)
      .notNull()

This is the generated SQL

ALTER TABLE "users" ADD COLUMN "roles" UserRole[] DEFAULT ARRAY['STUDENT']::UserRole[] NOT NULL;

ALTER TABLE "users" ADD COLUMN "roles" UserRole[] DEFAULT ARRAY['STUDENT']::UserRole[] NOT NULL;

We're using drizzle kit version

0.21.2

0.21.2

.
Any help is appreciated, thank you!

Drizzle Team•2y ago

ethan

error: type "userrole[]" does not exist

So when I'm running db:push I'm getting an error that the enum userrole doesnt exist. I have the enum here and it shows in the supabase enums list as well.

This is the code

enum
export const userRole = pgEnum("UserRole", ["ADMIN", "TEACHER", "DEVELOPER", "STUDENT", "ALUMNI", "GUEST"]);

table attr
roles: userRole("roles")
      .array()
      .default(sql`ARRAY['STUDENT']::UserRole[]`)
      .notNull()

enum
export const userRole = pgEnum("UserRole", ["ADMIN", "TEACHER", "DEVELOPER", "STUDENT", "ALUMNI", "GUEST"]);

table attr
roles: userRole("roles")
      .array()
      .default(sql`ARRAY['STUDENT']::UserRole[]`)
      .notNull()

This is the generated SQL

ALTER TABLE "users" ADD COLUMN "roles" UserRole[] DEFAULT ARRAY['STUDENT']::UserRole[] NOT NULL;

ALTER TABLE "users" ADD COLUMN "roles" UserRole[] DEFAULT ARRAY['STUDENT']::UserRole[] NOT NULL;

We're using drizzle kit version

0.21.2

0.21.2

.
Any help is appreciated, thank you!

error: type "userrole[]" does not exist

Similar Threads

error: type "userrole[]" does not exist

Similar Threads

Similar Threads

Similar Threads