[postgis-users] shp2pgsql: unterminated quotet string - spatial_ref_sys dropped

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Fri Feb 29 01:49:23 PST 2008

On Monday 25 February 2008 15:36:14 Andreas Laggner wrote:
> Hi list,
> if i want to import a shapefile i often gets this error. Since now i
> always could eleminate the error by transfering the data from shape to
> file geodatabase and back in arcgis9.2. But not with my actual dataset!
> I have done all repairs and transfers in arcgis - i even splited the
> data - no success. He always sets the error mark before the 'SRID
> FEHLER:  Fehler »Zeichenkette nicht abgeschlossen« bei »'SRID=31467;«
> ZEILE 1: ...ULL,'0','7.40243892661e+000','3.63388095405e-003','SRID=3146...
> I do not know if this associated with the fact, that someone dropped the
> spatial_ref_sys from the public scheme. The error first occurs after
> that accident?! I just copied a spatial_ref_sys table from another
> postgis running local on winxp to the linux postgis where the table was
> dropped, they had akin versions of postgresql/postgis installed.
> cheers      Andreas

Hi Andreas,

Sounds like an escaping problem - have you got mis-matched apostrophes 
somewhere in the file close to the where the error is reported? Also which 
version of PostgreSQL/PostGIS are you using? You may need to check the 
setting of standard_conforming_strings in postgresql.conf.



Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
T: +44 870 608 0063

More information about the postgis-users mailing list