[postgis-users] PostGIS on multiple schemas
schabi at logix-tt.com
Thu Jan 12 06:01:20 PST 2006
Arnaud Lesauvage wrote:
> Now I have a new schema, and since all the postgis functions were
> created in the other one I have to reinstall them in this new one.
> I just added :
> SET search_path TO my_new_schema;
> on line 1 of lwpostgis.sql, but I have an error "ERROR: cast from type
> bool to type text already exists".
> What is the correct procedure to install postgis functions in all the
> schemas of my database ?
Having different PostGIS installations in different schemas of the same
database is currently not supported.
Usually, one has the PostGIS installed in a global schema (public or
postgis for example), and then uses this global PostGIS definitions to
create spatial tables in all the user schemas.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
More information about the postgis-users