[postgis-users] Trouble with shp2pgsql-gui?

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Fri Oct 7 05:24:49 PDT 2011

On 05/10/11 14:09, MarkW wrote:

> John - SET CLIENT.... is the beginning of a larger SQL statement. The
> error says the SQL statement failed, "...sql begins:"
> and then later down the error dump indicates a connectivity issue -
> which you later identified as the probable cause.
> So it is not saying the encoding is the failure, just that that was
> first line in SQL block submitted to pg server.
> Mark

Yes, that's correct. Did you check your connection using the conncetion 
test button before trying to load your data?

If the connection test succeeds but the header SQL doesn't, perhaps 
you're trying to load the data into a database that isn't PostGIS enabled?



Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs

More information about the postgis-users mailing list