[postgis-users] Shp2pgsql load error

[Kralidis,Tom [Burlington]]

> -----Original Message-----
> From: Kralidis,Tom [Burlington] 
> Sent: Tuesday, 24 May, 2005 13:09
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] Shp2pgsql load error
> 
> 
> > > 
> > > 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','SR
> ID=42304;<SNIP>
> 
> Program received signal SIGSEGV, Segmentation fault.
> 0x00872f18 in _int_malloc () from /lib/tls/libc.so.6
> 

Whoops, forgot trace to shp2pgsql.c:

#0  0x00872f18 in _int_malloc () from /lib/tls/libc.so.6
#1  0x0087225d in malloc () from /lib/tls/libc.so.6
#2  0x0804dc5a in safe_malloc (size=4) at shp2pgsql.c:130
#3  0x0804ed41 in FindPolygons (obj=0x8a92a30, Out=0x1) at
shp2pgsql.c:847
#4  0x0804f12c in InsertPolygon () at shp2pgsql.c:997
#5  0x0804e62b in LoadData () at shp2pgsql.c:640
#6  0x0804e10c in main (ARGC=7, ARGV=0xbfe437f4) at shp2pgsql.c:401