Thanks for the reply, Barend. I'm not sure what you mean though. Since
we're using the gui, I've already given the path because that's how we
chose a shape file to upload. I know of no other way to specify the
path for the shape file source.
Later today we managed to finally get the file to upload: I suspect the
issue was spotty connectivity with the server, though I'm still mystfied
about the UTF8 encoding failure:
>>Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
Kind regards,
JB
John Brisbin
Managing Director, BoaB interactive Pty Ltd
POB 802 Townsville, QLD 4810
M: 0407 471 565 | P: 07 3103 0574
Skype: boabjohn | Twitter: @boabjohn
On 5/10/2011 6:57 PM, Barend Köbben wrote:
He solution might be simply that somewhere further in the SQL it tries to
find your shape-file and fails. What is the path you provided for the
shape-file...?
Barend
On 05-10-11 04:05, "John Brisbin"<[email protected]> wrote:
G'Day all,
We're in the early stages of familiarising ourselves with the basic
management tools and procedures, so apologies in advance if this is well
documented (somewhere?).
We're running in a Debian (lenny) environment, using pgAdmin3 (1.14.0),
and have manually installed the shp2pgsql-gui (2.0).
In attempting to upload a well-formed ESRI shapefile with GCS_WGS_1984
projection, we get the following messages in the uploader gui:
Shapefile type: Polygon
PostGIS type: MULTIPOLYGON[2]
Failed SQL begins: "SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "public"."ro310_socio-econ" (gid serial,
"idnum" int2,
"fid_" varchar(254),
"aus_" numeric,
"aus_id" numeric,
"f_code" varchar(254),
"bname" varchar(254),
"bnum" varc"
Failed in pgui_exec(): could not receive data from server: The system
cannot find the path specified.
(0x00000003/3)
Shapefile import failed.
<<<
It looks like there is a problem with the encoding (why?) and then later
on there is a problem with the connection to the database (is that right?)
Looking for any guidance: much appreciated!
Kind regards,
JB
--
John Brisbin
Managing Director, BoaB interactive Pty Ltd
POB 802 Townsville, QLD 4810
M: 0407 471 565 | P: 07 3103 0574
Skype: boabjohn | Twitter: @boabjohn
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
Faculty of Geo-Information Science and Earth Observation (ITC)
University of Twente
Chamber of Commerce: 501305360000
E-mail disclaimer
The information in this e-mail, including any attachments, is intended for the
addressee only. If you are not the intended recipient, you are hereby notified
that any disclosure, copying, distribution or action in relation to the content
of this information is strictly prohibited. If you have received this e-mail by
mistake, please delete the message and any attachment and inform the sender by
return e-mail. ITC accepts no liability for any error or omission in the
message content or for damage of any kind that may arise as a result of e-mail
transmission.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
