DT
Drizzle TeamEntsllor

[BUG?] Handling Postgresql schemas when using enums

"drizzle-orm": "^0.30.10" Hello. I have a simple table with a status column 
export const BaseSchema = pgSchema(settings.DB_SCHEMA_NAME); // DB_SCHEMA_NAME=my_schema
export const statusEnum = BaseSchema.enum("version_status", values);

export const versions = BaseSchema.table("versions", {
    status: statusEnum("status").default(VersionStatus.draft),
    // ...rest columns
});
export const BaseSchema = pgSchema(settings.DB_SCHEMA_NAME); // DB_SCHEMA_NAME=my_schema
export const statusEnum = BaseSchema.enum("version_status", values);

export const versions = BaseSchema.table("versions", {
    status: statusEnum("status").default(VersionStatus.draft),
    // ...rest columns
});
When I generate new migration I get this 
 CREATE TYPE "version_status" AS ENUM('draft', 'published', 'inactive');
 CREATE TYPE "version_status" AS ENUM('draft', 'published', 'inactive');
But it does not consider DB_SCHEMA_NAME, and this type will be stored in public.object types instead of my_schema.object types I expect something like this: 
 CREATE TYPE "my_schema"."version_status" AS ENUM('draft', 'published', 'inactive');
 CREATE TYPE "my_schema"."version_status" AS ENUM('draft', 'published', 'inactive');
eXecuteye
eXecuteye•16d ago
Ran into the same issue today
Want results from more Discord servers?
Add your server
More Posts
Help needed for Nested QueryFor this example, I have 4 tables - `user`, `podcast`, `episodes`, and `bookmarks`. - bookmarks tablHow to init sqlite project?https://github.com/drizzle-team/drizzle-orm/issues/2240 ?Typescript performance in larger codebases?Hey, I've been using drizzle with small projects, but now I'm thinking of migrating a larger codebasmultiple dbs, multiple drizzle client, not registering as multiple dbsHey all, anyone know why apiDb shows up as not working? Originally when I had `keys` schema imported