shp2pgsql fails on altering target table (and subsequently)

[leaffan]

Dear all, unfortunately I have a bug to report. For me, shp2pgsql fails on a 64bit installation on Windows 7. This also happens on a clean install (PostgresSQL 9.2.3 x64 + PostGIS 2.0.3 x64). This is a sample output of the failing command:

C:\Program Files\PostgreSQL\9.2\bin>shp2pgsql.exe d:\sync\shp\wp4_extent.shp wp4_extent
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "wp4_extent" (gid serial,
"id" int4);
'MIdINSERT INTO "wp4_extent" ("id",geom) VALUES ('0','');
COMMIT;

While this is what happens when I use shp2pgsql from version 2.0.½.0.2:

C:\Program Files\PostgreSQL\9.2\bin>shp2pgsql_.exe d:\sync\shp\wp4_extent.shp wp4_extent
Shapefile type: Polygon
Postgis type: MULTIPOLYGON[2]
SET CLIENT_ENCODING TO UTF8;
SET STANDARD_CONFORMING_STRINGS TO ON;
BEGIN;
CREATE TABLE "wp4_extent" (gid serial,
"id" int4);
ALTER TABLE "wp4_extent" ADD PRIMARY KEY (gid);
SELECT AddGeometryColumn('','wp4_extent','geom','0','MULTIPOLYGON',2);
INSERT INTO "wp4_extent" ("id",geom) VALUES ('0','0106000000010000000103000000010000000500000000DF107759530441D4EDF205363A5841804B35B314842E41D4EDF205363A5841804B35B314842E41F0D6C771657E534100DF107759530441F0D6C771657E534100DF107759530441D4EDF205363A5841');
COMMIT;

Maybe someone can confirm - or even better - fix this. Thanks in advance. Regards, Markus

[robe]

bummer. Okay will check on this

[robe]

leaffan,

Can you do me a favor and try the same process using the gui — shp2pgsql-gui packaged.

I'm suspecting its the NLS stuff biting which is similar to here #2230

[robe]

Yap confirmed. I'm definitely seeing something screwy. I suspect I forgot to put in a replace hack I normally do for x64 bit.

[robe]

leaffan,

I'm rebuilding the packages. In meantime can you check and see if the one from 2.0.4SVN zip fixes your issue. ​http://winnie.postgis.net/download/windows/pg92/buildbot/

I thought my tag job was regressing, but it wasn't which is why it slipped thru the cracks.

[robe]

This also effects the postgis.dll so you're want to replace the libraries as well in lib folder.

[robe]

Leaffan,

Sorry about this and thanks for the bug report. Really important catch.

I've repackaged. The good one has a -2.exe and can download from — ​http://download.osgeo.org/postgis/windows/pg92/ This effects the core postgis functionality, so you'll want to reinstall

[leaffan]

Hej, downloaded the package again, retried and it worked. Thanks for the quick fix. Regards, Markus