[postgis-users] Trouble with shp2pgsql-gui?
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.
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