[postgis-users] Shp2pgsql load error

[Kralidis,Tom [Burlington]]

> > 
> > Hi,
> > 
> > Thanks for the previous help on the encoding issues.  When trying 
> > again with the following command:
> > 
> > $ /usr/local/pgsql/bin/shp2pgsql -W ISO8859-1 -s 42304 wshed_p 
> > public.wshed_p | /usr/local/pgsql/bin/psql -d devgeodb -U postgres
> > 
> > ERROR:  unterminated quoted string at or near 
> > 
> "'SRID=42304;<SNIP_TONS_OF_GEOMETRY>64BA4041F6365E936DC3F8400151CD483F
> > BA
> > 404199B6A0E30AC4F8406EA" at character 158
> > LINE 1:
> > ...066.31678','281229.63625','485','01AM','Oromocto','SRID=4230...
> > 
> > Any suggestions?
> 
> First of all redirect to a file instead of piping.
> Then run psql -f on that file, so the error will tell you 
> line number causing it.
> Collapse your TONS of geometry and see what sound wrong in quoting.
> 
  
I can't even get that far because shp2pgsql gives me back a segfault
when I want to redirect to file.  So trying this in gdb:

$ gdb /usr/local/pgsql/bin/shp2pgsql
$ run -W ISO8859-1 -s 42304 wshed_p public.wshed_p
<SNIP>
$ 
INSERT INTO "public"."wshed_p"
("area","perimeter","wshed_","wshed","shedname","the_geom") VALUES
('2127022066.31678','281229.63625','485','01AM','Oromocto','SRID=42304;<
SNIP>

Program received signal SIGSEGV, Segmentation fault.
0x00872f18 in _int_malloc () from /lib/tls/libc.so.6