[postgis-users] PostGIS on multiple schemas

Don Drake 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'

to postgresql.conf.

It's easier if you keep PostGIS in public when you add schemas, then you
won't have to deal with these problems.


-----Original Message-----
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 mailing list