[#198] PostGIS: Thuban doesn't support PostgreSQL schema

Date:
2006-10-17 13:33
Priority:
2
State:
Open
Submitted by:
Frank Koormann (frank)
Assigned to:
Nobody (None)
Category:
none
Version:
none
Summary:
PostGIS: Thuban doesn't support PostgreSQL schema

Detailed description
Thuban expects the data always in the default schema (public) and does not support the PostgreSQL schema concept.
Message  ↓
Date: 2006-11-06 10:26
Sender: Bernhard Reiter

I think this is a feature request.

Date: 2006-10-20 07:27
Sender: Frank Koormann

To explain this a bit more: Since v7.3 PostgreSQL supports schemas, a concept to organize tables within a database.

schema names are preceeding table names on access:

select * from bar;
- access table bar in the public schema.

select * from foo.bar;
- access table bar in the schema foo.

So probably it would be sufficient to enhance the table name handling in Thuban.

No attached documents

Field Old Value Date By
priority32006-11-06 10:26Bernhard Reiter