[postgis-users] Severe shapefile upload issues

Paragon Corporation lr at pcorp.us
Fri Apr 6 17:03:30 PDT 2012

Hmm strange works all fine on my window box and my postgres doesn't have
it's own search_paths.

You did set the search path of the database right?
Mine is like this:

ALTER DATABASE mygisdb SET search_path="$user", postgis, public,  contrib;

and it works fine for all users.  I do have user specific schemas thus the
need for "$user"

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of THX1138
> Sent: Friday, April 06, 2012 5:36 PM
> To: postgis-users at postgis.refractions.net
> Subject: Re: [postgis-users] Severe shapefile upload issues
> Everything imports fine if I do not use the transform. I 
> would also point out that the srid conversion functionality 
> is missing in the shapefile/dbf loader GUI in pgadmin as 
> there is no box for convert srid. 
> As to my path issues, if I do not change my user path 
> addgeometrycolumn fails.
> I used: 
> ALTER ROLE postgres RESET search_path; 
> and it yielded the function does not exist error. When I 
> changed it back it worked fine again. 
> From what I can tell, set search_path to seems to only affect 
> the database temporarily for the given session. The reason 
> why it seems to be failing is because in order to execute an 
> query involving postgis one would need to run "set 
> search_path to postgis,..." in a preceding query in the same 
> session in order for it to take, whereas if you change the 
> users path it sets the path permanently.
> It seems to fail differently on different systems as well. 
> For example, if I do not change the user path on my windows 
> postgres I cannot even use  postgis_full_version() but this 
> works fine on my linux install without altering my user path. 
> In pg_db_role_setting there is originally no data for the 
> user search path.
> When I add a user search path I get back:
> "{"search_path=public, postgis"}"
> When I reset the role it simply deletes the entry again and 
> processes begin to fail.
> Is there  a way to permanently set the database search path 
> without changing the user's search path?
> Thanks,
> THX1138
> --
> View this message in context: 
> http://postgis.17.n6.nabble.com/Severe-shapefile-upload-issues
> -tp4690980p4693779.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

More information about the postgis-users mailing list