[postgis-users] Subject: Re: raster2pgsql 2.1.1 on Windows 7 64bit - ERREUR: erreur de syntaxe

[Guillaume Drolet]

I tried the same command as in my previous post on my PC at home. It's
Windows 7 64bit as well and the cluster has the same locale
('French.Canadian.1252'.) and encoding (UTF8).

The command was successful so my work colleague and I, who experiences
the same behaviour as the one described previously on this list,
suspect that it may be due to some problems or conflict between
PostGIS and the hardware (we have similar systems): is this a sensible
hypothesis?

Thanks for your help,

Guillaume

> Message: 4
> Date: Thu, 17 Apr 2014 17:03:58 -0400
> From: Guillaume Drolet <droletguillaume at gmail.com>
> To: "postgis-users at lists.osgeo.org" <postgis-users at lists.osgeo.org>
> Subject: [postgis-users] Subject: Re: raster2pgsql 2.1.1 on Windows 7
>         64bit - ERREUR: erreur de syntaxe
> Message-ID:
>         <CAOkiyv5VHw2XTCAnA1nFMwhvbfnBpHEJBNpyGURw73Vs=kXPUg at mail.gmail.com>
> Content-Type: text/plain; charset=UTF-8
>
> Regina, Remi:
>
> No space in filenames. GDAL version is 1.11dev. I don't have any
> problems importing shapefiles into PostGIS.
>
> Encoding was already UTF8 but I tried your suggestion (SET
> PGCLIENT...) and I still have errors with SQL files having incomplete
> last line.
>
> I noticed that my LC_COLLATE and LC_TYPE are both set
> 'French.Canadian.1252'. Maybe this is the source of the problem. I
> tried creating a new cluster with --no-locale to make some tests with
> raster2pgsql but I screwed up and messed with my current cluster in
> the process...
>
> Will do more tests when I'm back from Easter Holiday and I fixed my
> cluster problem.
> Thanks for your help.
>
> Best,
>
> Guillaume