Enum Error When Push

D:\projects\wildcard\icc2>npx drizzle-kit push
No config path provided, using default 'drizzle.config.ts'
Reading config file 'D:\projects\wildcard\icc2\drizzle.config.ts'
Using 'pg' driver for database querying
[✓] Pulling schema from database...
error: column "role" cannot be cast automatically to type role
at D:\projects\wildcard\icc2\node_modules\pg-pool\index.js:45:11
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async Object.query (D:\projects\wildcard\icc2\node_modules\drizzle-kit\bin.cjs:76384:26)
at async pgPush (D:\projects\wildcard\icc2\node_modules\drizzle-kit\bin.cjs:79407:13)
at async Object.handler (D:\projects\wildcard\icc2\node_modules\drizzle-kit\bin.cjs:88704:9)
at async run (D:\projects\wildcard\icc2\node_modules\drizzle-kit\bin.cjs:87030:7) {
length: 173,
severity: 'ERROR',
code: '42804',
detail: undefined,
hint: 'You might need to specify "USING role::role".',
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'tablecmds.c',
line: '12353',
routine: 'ATPrepAlterColumnType'
}
D:\projects\wildcard\icc2>npx drizzle-kit push
No config path provided, using default 'drizzle.config.ts'
Reading config file 'D:\projects\wildcard\icc2\drizzle.config.ts'
Using 'pg' driver for database querying
[✓] Pulling schema from database...
error: column "role" cannot be cast automatically to type role
at D:\projects\wildcard\icc2\node_modules\pg-pool\index.js:45:11
at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
at async Object.query (D:\projects\wildcard\icc2\node_modules\drizzle-kit\bin.cjs:76384:26)
at async pgPush (D:\projects\wildcard\icc2\node_modules\drizzle-kit\bin.cjs:79407:13)
at async Object.handler (D:\projects\wildcard\icc2\node_modules\drizzle-kit\bin.cjs:88704:9)
at async run (D:\projects\wildcard\icc2\node_modules\drizzle-kit\bin.cjs:87030:7) {
length: 173,
severity: 'ERROR',
code: '42804',
detail: undefined,
hint: 'You might need to specify "USING role::role".',
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'tablecmds.c',
line: '12353',
routine: 'ATPrepAlterColumnType'
}
import { pgTable, text, boolean, date, integer, pgEnum } from 'drizzle-orm/pg-core';
import { sql } from 'drizzle-orm';

export const enumRole = pgEnum('role', [
'STUDENT',
'TEACHER',
'ADMIN'
]);

export const user = pgTable('users', {
id: integer().primaryKey(),

username: text().unique().notNull(),
email: text().unique().notNull(),
password: text().notNull(),
isActive: boolean().default(false),
role: enumRole(),

avatar: text(),
banner: text(),
fullName: text(),
bio: text(),

createdAt: date().default(sql`CURRENT_TIMESTAMP`),
updatedAt: date().default(sql`CURRENT_TIMESTAMP`).$onUpdate(() => sql`CURRENT_TIMESTAMP`),
});
import { pgTable, text, boolean, date, integer, pgEnum } from 'drizzle-orm/pg-core';
import { sql } from 'drizzle-orm';

export const enumRole = pgEnum('role', [
'STUDENT',
'TEACHER',
'ADMIN'
]);

export const user = pgTable('users', {
id: integer().primaryKey(),

username: text().unique().notNull(),
email: text().unique().notNull(),
password: text().notNull(),
isActive: boolean().default(false),
role: enumRole(),

avatar: text(),
banner: text(),
fullName: text(),
bio: text(),

createdAt: date().default(sql`CURRENT_TIMESTAMP`),
updatedAt: date().default(sql`CURRENT_TIMESTAMP`).$onUpdate(() => sql`CURRENT_TIMESTAMP`),
});
1 Reply
LowScarlet
LowScarletOP4w ago
idk what thats mean, i have chatgpt but looks like its outdate and there no issue like this in stackoverflow, i have search same issue in here but just get this https://discord.com/channels/1043890932593987624/1309868069023252490/1309890781321891951 and this not solve my problem up
Want results from more Discord servers?
Add your server