#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 |
---------------------------------------------+------------------------------
Changes (by jonas):
* status: new => assigned
Comment:
As soon as a new postgresql connection is established the search path is
set to first look in the specified schema and after that "public".
The most likely explanation for this error message is that an incorrect
schema name (or non at all) is specified in the database connection
string. Can you please verify that you have a connection string like this
in your trac.ini:
{{{
database = postgres:///database?schema=yourschemaname
or
database = postgres://user:[EMAIL PROTECTED]/database?schema=yourschemaname
}}}
--
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
