Opened 18 years ago
Last modified 13 months ago
#3308 closed defect
"relation "system" does not exist" when using multiple Postgres schema in same DB — at Initial Version
| Reported by: | Owned by: | Jonas Borgström | |
|---|---|---|---|
| Priority: | normal | Milestone: | 0.10 |
| Component: | general | Version: | devel |
| Severity: | major | Keywords: | schema, relation, system, feedback, postgresql |
| Cc: | Branch: | ||
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
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?
Note:
See TracTickets
for help on using tickets.
