19 replies

Drizzle not creating enum

Hey guys, I am using drizzle in my project with postgres. I create a new enum(with pgenum) but the generate sql is missing the definition of the enum.

const status = pgEnum('status', [
    'created',
    'generating',
    'generated',
    'error',
]);

const status = pgEnum('status', [
    'created',
    'generating',
    'generated',
    'error',
]);

and using this as

status: status().notNull().default('created')

status: status().notNull().default('created')

and here's the generated sql

CREATE TABLE "curriculums" (
    "id" varchar PRIMARY KEY NOT NULL,
    "user_id" varchar NOT NULL,
    "language_id" varchar NOT NULL,
    "created_at" varchar DEFAULT now() NOT NULL,
    "status" "status" DEFAULT 'created' NOT NULL,
    "reason" varchar DEFAULT '' NOT NULL,
    "knowledge" varchar DEFAULT '' NOT NULL
);

CREATE TABLE "curriculums" (
    "id" varchar PRIMARY KEY NOT NULL,
    "user_id" varchar NOT NULL,
    "language_id" varchar NOT NULL,
    "created_at" varchar DEFAULT now() NOT NULL,
    "status" "status" DEFAULT 'created' NOT NULL,
    "reason" varchar DEFAULT '' NOT NULL,
    "knowledge" varchar DEFAULT '' NOT NULL
);

there's no definition of enum

Drizzle Team•15mo ago•

19 replies

Nova

Drizzle not creating enum

Hey guys, I am using drizzle in my project with postgres. I create a new enum(with pgenum) but the generate sql is missing the definition of the enum.

const status = pgEnum('status', [
    'created',
    'generating',
    'generated',
    'error',
]);

const status = pgEnum('status', [
    'created',
    'generating',
    'generated',
    'error',
]);

and using this as

status: status().notNull().default('created')

status: status().notNull().default('created')

and here's the generated sql

CREATE TABLE "curriculums" (
    "id" varchar PRIMARY KEY NOT NULL,
    "user_id" varchar NOT NULL,
    "language_id" varchar NOT NULL,
    "created_at" varchar DEFAULT now() NOT NULL,
    "status" "status" DEFAULT 'created' NOT NULL,
    "reason" varchar DEFAULT '' NOT NULL,
    "knowledge" varchar DEFAULT '' NOT NULL
);

CREATE TABLE "curriculums" (
    "id" varchar PRIMARY KEY NOT NULL,
    "user_id" varchar NOT NULL,
    "language_id" varchar NOT NULL,
    "created_at" varchar DEFAULT now() NOT NULL,
    "status" "status" DEFAULT 'created' NOT NULL,
    "reason" varchar DEFAULT '' NOT NULL,
    "knowledge" varchar DEFAULT '' NOT NULL
);

there's no definition of enum

Drizzle not creating enum

Similar Threads

Drizzle not creating enum

Similar Threads

Similar Threads

Similar Threads