#3308: "relation "system" does not exist" when using multiple Postgres schema in
same DB
---------------------------+------------------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: jonas
Type: defect | Status: new
Priority: normal | Milestone: 0.10
Component: general | Version: devel
Severity: major | Keywords: schema postgres relation system
---------------------------+------------------------------------------------
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 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?
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3308>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
