drizzle-team / drizzle-team/drizzle-orm
`drizzle-kit push` executes bad query for postgres enum types
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
this is how i defined my enum:
```ts
export const transactionProvider = pgEnum("transaction_provider", [
"zibal",
"idpay",
"manual",
]);
```
output of `drizzle-kit push`;
```
$ npx drizzle-kit push
drizzle-kit: v0.22.7
drizzle-orm: v0.31.2
No config path provided, using default path
Reading config file '/home/erfanium/Documents/imed/my-app/drizzle.config.ts'
Using 'pg' driver for database querying
[✓] Pulling schema from database...
Warning You are about to execute current statements:
ALTER TYPE "transaction_provider" ADD VALUE 'zibal';
error: enum label "zibal" already exists
at /home/erfanium/Documents/imed/my-app/node_modules/drizzle-kit/bin.cjs:77696:15
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Object.query (/home/erfanium/Documents/imed/my-app/node_modules/drizzle-kit/bin.cjs:119635:26)
at async pgPush (/home/erfanium/Documents/imed/my-app/node_modules/drizzle-kit/bin.cjs:122560:13)
at async _Command. (/home/erfanium/Documents/imed/my-app/node_modules/drizzle-kit/bin.cjs:129681:7) {
length: 91,
severity: 'ERROR',
code: '42710',
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'pg_enum.c',
line: '264',
routine: 'AddEnumLabel'
}
```
I could investigate more If i had access to the source code.
Contributor guide
Assessment
This issue has not been assessed yet.