© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Team•2y ago•
1 reply
Entsllor

[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
public.object types
instead of
my_schema.object types
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');
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Problem with ENUMs PostgreSQL
Drizzle TeamDTDrizzle Team / help
14mo ago
Enums
Drizzle TeamDTDrizzle Team / help
2y ago
Enums
Drizzle TeamDTDrizzle Team / help
3y ago
Guidance on Creating a Multi-Tenant Application with PostgreSQL Schemas
Drizzle TeamDTDrizzle Team / help
15mo ago