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

[Mark Cave-Ayland]

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.


HTH,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063