#3308: "relation "system" does not exist" when using multiple Postgres schema in
same DB
------------------------------------------------------+---------------------
Reporter: [EMAIL PROTECTED] | Owner:
jonas
Type: defect | Status: assigned
Priority: normal | Milestone: 0.10
Component: general | Version: devel
Severity: major | Resolution:
Keywords: schema postgres relation system feedback |
------------------------------------------------------+---------------------
Changes (by cboos):
* keywords: schema postgres relation system => schema postgres relation
system feedback
Old 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?
New 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 ''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?
--
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
