[postgis-users] raster2pgsql quoted string error

[Paragon Corporation]

Jean,

You may want to double-check you have the latest raster2pgsql.  Even though
your PostGIS is up to date, your raster2pgsql might be older.

I recall having this issue in 2.0 and Bborie fixed it.

Can't remember the exact ticket and don't have raster2pgsql in front of me,
but I think if you run it without args it gives the revisions number.

Hope that helps,
Regina
http://www.postgis.us

 

-----Original Message-----
From: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Bborie Park
Sent: Thursday, November 01, 2012 12:54 PM
To: postgis-users at lists.osgeo.org
Subject: Re: [postgis-users] raster2pgsql quoted string error

Hey Jean-Daniel,

That error doesn't make sense as nothing in the loader would prematurely cut
the output.  Are you able to show the last several lines of the sql file
(pre-edit).

-bborie

On 11/01/2012 08:05 AM, Jean-Daniel Sylvain wrote:
> Dear PGIS users,
> 
> I'm working with the postgis 2.0 :
> 
> 1. PostgreSQL 9.1.4, compiled by Visual C++ build 1500, 64-bit"
> 2. "POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6
>    March 2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
>    LIBJSON="UNKNOWN" RASTER"
> 
> I'm trying to load a raster.tif (DEM) into  my database with the 
> following command.
> 
> raster2pgsql -f elev -F -t 100x100  QC_SRTM.tif QC_SRTM | psql -U 
> postgres -d DEM -h localhost -p 5432
> 
> And I catched this error;
> 
> INSERT 0 1
> INSERT 0 1
> INSERT 0 1
> INSERT 0 1
> INSERT 0 1
> INSERT 0 1
> INSERT 0 1
> INSERT 0 1
> psql:elev1.sql:5690: ERREUR:  chaîne entre guillemets non terminée sur 
> ou près de « '010000010000000....
> 
> ..... indicating that the string is not quoted near the last line.
> 
> So I ran  the raster2pgsql.exe with this command
> 
> D:\Data\Geodata\Altimetrie\SRTM\DEM90m\PreTraitement>raster2pgsql -f 
> elev -F -t 100x100  QC_SRTM.tif QC_SRTM > InsertSRTM.sql Processing 
> 1/1: QC_SRTM.sdat
> 
> and looked at the content of the sql file. The last line of the file 
> is cut and the command "END;" is not there.
> 
> If I correct the file by ending the line and adding the "End;" command 
> the file is load.
> 
> I was wondering what parameter would be responsible for that error in 
> raster2pgsql?
> 
> I have many raster to load so this temporary solution is not a TRUE 
> solution. Anyone had an idea?
> 
> Thanks.
> 
> Jean-Daniel
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 

--
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users