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-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@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-boun...@postgis.refractions.net > > [mailto:postgis-users-boun...@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@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@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
