- changed status to resolved
Cannot create a table called 'domains' in PostgreSQL 8.1 due to a conflict with 'domains' object in information_schema
Issue #424
resolved
When running .create_all() on a model that creates a table called 'domains' the table won't get created. SQLalchemy runs the query:
select relname from pg_class where lower(relname) = 'domains'
That query returns something because the information_schema in PostgreSQL has an object called 'domains'. My model even uses a certain PostgreSQL schema (namespace) so that SQLalchemy wouldn't even find the 'domains' object there. But the "select relname from pg_class..." query is too generic.
I need to run .create_all() with parameters checkfirst=None. But that will break the second time I try it.
Comments (1)
-
repo owner - Log in to comment
pls verify the changes I made in changeset:2208 are sane...