[postgis-users] Schemas in 7.3

David Blasby dblasby at refractions.net
Thu Feb 6 14:23:16 PST 2003


Currently, geometry columns has:

                Table "geometry_columns"
      Column       |          Type          | Modifiers
-------------------+------------------------+-----------
 f_table_catalog   | character varying(256) | not null
 f_table_schema    | character varying(256) | not null
 f_table_name      | character varying(256) | not null
 f_geometry_column | character varying(256) | not null
...

The "f_table_catalog" and "f_table_schema" are for 'higher' levels of
organization.  So, it makes sense to have the metadata table in a high level
tablespace.

If you make the postgis installation local to a single schema, problems might
occur.  For example, two users could put two [possibly diffent versions] postgis
installations in different tables spaces.  Postgresql would be very confused
about what a "GEOMETRY" type refered to (ie. DAVE.GEOMETRY or PAUL.GEOMETRY) and
if you tried to cross connect the two geometry types, you'll probably not get
them to behave.

I think the best idea to put everything in the system tablespace or only allow
one user tablespace to have it installed.

dave
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20030206/8516f073/attachment.html>


More information about the postgis-users mailing list