I have some enum types on a schema, but I can't define it in drizzle-orm.

I have defined a couple of enums in another schema, let's say main.

Now I want to define it in drizzle-orm, there's the

pgEnum

pgEnum

but if I use it, when creating migrations or pushing to the database it'll try to change the table column types from

main.enum_name

main.enum_name

enum_name

enum_name

which fails.

It'll be great if we had something similar to the

schema.table

schema.table

but for enums (

schema.enum

schema.enum

).

Also drizzle kit doesn't generate the correct schema because of this. It creates the enums but it doesn't connect them to the correct schema.

I have defined a couple of enums in another schema, let's say main.

Now I want to define it in drizzle-orm, there's the

pgEnum

pgEnum

but if I use it, when creating migrations or pushing to the database it'll try to change the table column types from

main.enum_name

main.enum_name

enum_name

enum_name

which fails.

It'll be great if we had something similar to the

schema.table

schema.table

but for enums (

schema.enum

schema.enum

).

Also drizzle kit doesn't generate the correct schema because of this. It creates the enums but it doesn't connect them to the correct schema.