drizzle-team / drizzle-team/drizzle-orm
[BUG]: Can't create index concurrently due to transaction block
Open
db/postgres
drizzle/kit
improvement
priority
- Dominant language
- TypeScript
- Stars
- 35.8k
- Forks
- 1.6k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 4
Description
### What version of `drizzle-orm` are you using?
0.27.0
### What version of `drizzle-kit` are you using?
0.19.3
### Describe the Bug
Creating an index with the `CONCURRENTLY` option throws this error: `CREATE INDEX CONCURRENTLY cannot run inside a transaction block`
### Expected behavior
There's should be an option to run a specific migration without a transaction.
### Environment & setup
Postgres 15.3
Contributor guide
Assessment
This issue has not been assessed yet.