[postgis-users] Severe shapefile upload issues

THX1138 ap.joseph at live.com
Fri Apr 6 14:36:03 PDT 2012

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

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

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?



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.

More information about the postgis-users mailing list