Cannot create a table called 'domains' in PostgreSQL 8.1 due to a conflict with 'domains' object in information_schema

Issue #424 resolved
Former user created an issue

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)

  1. Log in to comment