<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16866"></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><FONT
face="Times New Roman"><FONT color=#000000><FONT size=3>Guillaume<SPAN
class=356302108-17042014>,</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><FONT face="Times New Roman"><FONT
color=#000000><FONT color=#0000ff size=2 face=Arial><SPAN
class=356302108-17042014></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><FONT face="Times New Roman"><FONT
color=#000000><FONT size=3><SPAN class=356302108-17042014>What is the encoding
and client encoding of your database? I have run into this issue
before if I have a client encoding setting other than UTF8. To work around
it I force the client encoding to UTF8 during
load.</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><FONT face="Times New Roman"><FONT
color=#000000><FONT size=3><SPAN
class=356302108-17042014></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><FONT face="Times New Roman"><FONT
color=#000000><FONT size=3><SPAN class=356302108-17042014>So if your encoding is
different try in your batch script add this before you
load</SPAN></FONT></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><FONT face="Times New Roman"><FONT
color=#000000><FONT size=3><SPAN
class=356302108-17042014></SPAN></FONT></FONT></FONT></FONT> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial><SPAN class=356302108-17042014>SET
PGCLIENTENCODING=UTF8</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial><BR><FONT color=#0000ff
size=2></FONT></FONT></DIV>
<DIV><SPAN class=356302108-17042014></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>Hope that helps,</FONT></FONT></FONT></DIV>
<DIV><SPAN class=356302108-17042014></SPAN><SPAN
class=356302108-17042014></SPAN><FONT face=Arial><FONT color=#0000ff><FONT
size=2>R<SPAN
class=356302108-17042014>egina</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of
</B>droletguillaume<BR><B>Sent:</B> Wednesday, April 16, 2014 11:25
PM<BR><B>To:</B> postgis-users@lists.osgeo.org<BR><B>Subject:</B>
[postgis-users] raster2pgsql 2.1.1 on Windows 7 64bit - ERREUR: erreur de
syntaxe<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>
<DIV style="FONT-SIZE: 9px; COLOR: #575757">Sent from Samsung
Mobile</DIV></DIV><BR><BR>
<DIV style="COLOR: rgb(0,0,0); TEXT-ALIGN: left">
<DIV style="FONT-SIZE: 100%"><SPAN class=Apple-style-span
style="FONT-SIZE: medium">Hi,</SPAN></DIV></DIV><BR>The problem I have is
similar to this one from an old thread on this
list:<BR><BR>https://www.mail-archive.com/postgis-users@lists.osgeo.org/msg00013.html<BR><BR>I
have never succeeded to load a raster into PostGIS on my machine. In<BR>the
past, I have experienced the same type of error as the one presented in that old
thread above when trying to load rasters, mainly TIF files.
<DIV><BR></DIV>
<DIV>Today, I tried once again, thinking that my new version of PostGIS
(2.1.1) would solve the problem but no luck...<BR><BR>When I run this
command:<BR><BR>E:\data\>raster2pgsql -s 4326 -d -M -I -C -R -F -t
50x50<BR>MOD15A2.A2000049.h12v04.005.2<BR>006268184934_Lai_1km.tif modis.temp |
psql -d mortalite -U postgres<BR><BR>I get this:<BR>...<BR>...<BR><several
lines of INSERT 0 1><BR>INSERT 0 1<BR>INSERT 0 1<BR>INSERT 0 1<BR>INSERT 0
1<BR>INSERT 0 1<BR>INSERT 0 1<BR>CREATE INDEX<BR>ANALYZE<BR>ERREUR: erreur
de syntaxe à la fin de l'entrée<BR>LINE 1: SELECT
AddRasterConstraints('modis','temp'<BR><BR>If I redirect the output of
raster2pgsql to an SQL file, I can see that the last line of the file is
incomplete, which causes the error:<BR><BR>...<BR>INSERT INTO "modis"."temp"
("rast","filename")
VALUES<BR>('0100000100F69DBA4D1311813FF69DBA4D131181BF67341363EC7752C06392AE819989474000000000000000000000000000000000E610000032002A008700000000004D4F44313541322E41323030303034392E6831327630342E3030352E323030363236383138343933345F4C61695F316B6D2E74696600'::raster,'MOD15A2.A2000049.h12v04.005.2006268184934_Lai_1km.tif');<BR>INSERT
INTO "modis"."temp" ("rast","filename")
VALUES<BR>('0100000100F69DBA4D1311813FF69DBA4D131181BFD0C0E9B4415D52C06392AE819989474000000000000000000000000000000000E610000032002A008700000000004D4F44313541322E41323030303034392E6831327630342E3030352E323030363236383138343933345F4C61695F316B6D2E74696600'::raster,'MOD15A2.A2000049.h12v04.005.2006268184934_Lai_1km.tif');<BR>INSERT
INTO "modis"."temp" ("rast","filename")
VALUES<BR>('0100000100F69DBA4D1311813FF69DBA4D131181BFA3D99658EC2752C06392AE819989474000000000000000000000000000000000E610000019002A008700000000004D4F44313541322E41323030303034392E6831327630342E3030352E323030363236383138343933345F4C61695F316B6D2E74696600'::raster,'MOD15A2.A2000049.h12v04.005.2006268184934_Lai_1km.tif');<BR>CREATE
INDEX "temp_rast_gist" ON "modis"."temp" USING
gist<BR>(st_convexhull("rast"));<BR>ANALYZE "modis"."temp";<BR>SELECT
AddRasterConstraints('modis','temp'<BR><BR>This is very frustrating as since
2012, we've never been able to use any<BR>raster in PostGIS :(<BR><BR>Has anyone
ever experienced similar problems?<BR><BR>Thanks for
helping,<BR><BR>Guillaume<BR><BR></DIV></BODY></HTML>