"relation "system" does not exist" when using multiple Postgres schema in same DB
|Reported by:||Owned by:||Jonas Borgström|
|Severity:||major||Keywords:||schema, relation, system, feedback, postgresql|
Description (last modified by )
When using one Postgres DB with multiple schemas with Trac projects, there is must be "public" schema containing "system" table. In other words, database_version is wrongly checked against public schema, not schema of project.
I think problem is here:
File "/usr/lib/python2.4/site-packages/trac/env.py", line 235, in get_version cursor.execute("SELECT value FROM system WHERE name='database_version'")
Maybe schema specification before "system" needed?