[postgis-users] PostGIS on multiple schemas
don at drakeconsult.com
Thu Jan 12 06:03:01 PST 2006
I would try just leaving it where it is and adding:
search_path = '$user,public,my_old_schema'
It's easier if you keep PostGIS in public when you add schemas, then you
won't have to deal with these problems.
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Arnaud
Sent: Thursday, January 12, 2006 7:11 AM
To: PostGIS Users Discussion
Subject: [postgis-users] PostGIS on multiple schemas
Hi all !
I am trying to install postgis in different schemas in my database.
First I had only one schema (I have removed the public schema), so
I just ran lwpostgis.sql and spatial_ref_sys.sql on my database
and everything went fine.
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 ?
Thanks a lot for your help !
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users