kaiwu999 / alembic

Automatically exported from code.google.com/p/alembic
0 stars 0 forks source link

CREATE INDEX CONCURRENTLY cannot run inside a transaction block #305

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Create migration to add an index with a function, something like: 
op.execute("create index concurrently idx_users_some_attr_lower on users 
(lower(some_attr::text));")
2. Run migration
3. Watch it explode.

What is the expected output? What do you see instead?
I expected it to run just as when I manually run it in psql. Instead it gives 
me:
"sqlalchemy.exc.InternalError: (InternalError) CREATE INDEX CONCURRENTLY cannot 
run inside a transaction block"

What version of the product are you using? On what operating system?
0.4.2 on OS X 10.7.5

Please provide any additional information below.

Original issue reported on code.google.com by jess.m.s...@gmail.com on 28 Mar 2013 at 11:31

GoogleCodeExporter commented 8 years ago
You have the wrong Alembic project.  Try the sqlalchemy one.

Original comment by miller.lucas on 29 Mar 2013 at 2:24

GoogleCodeExporter commented 8 years ago
Apologies. It was a rough day.

Original comment by jess.m.s...@gmail.com on 30 Mar 2013 at 12:19