[postgis-users] How to set the parent schema of postgis 2.0 to"postgis" instead of "public"

[Paragon Corporation]

 I put in a ticket explaining what I think the issue is here:

http://trac.osgeo.org/postgis/ticket/1746

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Paragon Corporation
> Sent: Tuesday, April 03, 2012 12:56 AM
> To: 'PostGIS Users Discussion'
> Cc: 'THX1138'
> Subject: Re: [postgis-users] How to set the parent schema of 
> postgis 2.0 to"postgis" instead of "public"
> 
> Actually I'm not absolutely sure its the same thing.  I'll 
> put in a ticket myself, but it might be related.
> 
> When I move rc1 (which I had upgraded from beta2) to another 
> schema I am left with two functions in public.
> 
> st_dump, st_ivaliddetail
> 
> I think this is similar to what is happening to you.  I 
> suspect that these may have been dropped from the extension 
> and never readded possibly because their signature changed 
> and they shouldn't be there or there is something wrong with 
> create extension that is leaving these out.
> 
> If I upgrade a clean rc2 -- there is nothing left in public.
> 
> Those functions I see now are marked as taking 
> postgis.geometry as input. My st_makevalid still works though 
> and is moved to postgis.schema.  So you might want to just 
> upgrade to rc2
> 
> Do you see st_makevalid in public?
> 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net
> > [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
> > Andy Colson
> > Sent: Monday, April 02, 2012 10:41 PM
> > To: PostGIS Users Discussion
> > Cc: THX1138
> > Subject: Re: [postgis-users] How to set the parent schema 
> of postgis 
> > 2.0 to "postgis" instead of "public"
> > 
> > On 04/02/2012 06:40 PM, THX1138 wrote:
> > > Hello All,
> > > I am attempting to keep my non-gis information separate 
> from my gis 
> > > information and thus would like to create a separate 
> postgis schema 
> > > but I have run into some problems.
> > >
> > > I ran the following commands to move the data into a new schema:
> > >
> > > CREATE schema postgis;
> > > ALTER EXTENSION postgis SET SCHEMA postgis; SET search_path TO 
> > > "$user",public,postgis
> > >
> > > Yet, for some reason when I run a spatial query such as "select
> > > st_makevalid(geom) from jurisdictions", I get the following error:
> > >
> > > ERROR:  function st_makevalid(postgis.geometry) does not
> > exist LINE 1: 
> > > select st_makevalid(geom) from jurisdictions
> > >                 ^
> > > HINT:  No function matches the given name and argument types. You 
> > > might need to add explicit type casts.
> > >
> > > Can anyone point me in the right direction as to how to fix this?
> > >
> > > I am still using beta 3, so perhaps this error has been
> > fixed in later
> > > versions.
> > >
> > > Another problem might be that I have legacy functions  
> installed in 
> > > the public schema and that they somehow conflict with postgis 2.0 
> > > being installed in the postgis schema. If this is the case, is it 
> > > possible to import those functions into the postgis schema
> > as well (or
> > > their own schema)?
> > >
> > > Thanks
> > >
> > > THX1138
> > >
> > > --
> > > View this message in context: 
> > > 
> > 
> http://postgis.17.n6.nabble.com/How-to-set-the-parent-schema-of-postgi
> > > s-2-0-to-postgis-instead-of-public-tp4680493p4680493.html
> > > Sent from the PostGIS - User mailing list archive at Nabble.com.
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> > 
> > Not sure, but, maybe you need to create it up front:
> > 
> > 
> > CREATE extension postgis with SCHEMA postgis;
> > 
> > 
> > -Andy
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>