[postgis-users] ST_BandPath() returns null or ô on out-db raster

[Tumasgiu Rossini]

I write too fast...

problematics non escaped rasters doesn't output empty string. I checked it
with the length function.

Also, it seems that it is juste the output of St_bandpath wich is
problematic, because raster output functions like st_AsPng
seems to work...



2015-01-29 16:35 GMT+01:00 Tumasgiu Rossini <rossini.t at gmail.com>:

> Hi BBorie,
>
> Out-db rasters referenced with network path do register on postgis tables
> ! I use it every day.
>
> It was, like you suggested it, an escaping issue :
>
> I have tried the command
>
> raster2pgsql -R -a -F  \\serveur-ad/\raster/\419/\napoleonien/\*.tif
> testraster  | psql -U postgres -p 5434 test
>
> and it works. Thanks for the hint !
>
> It is the '\419' part wich causes troubles, I renamed the directory and it
> worked with the non-escaped. I think it is because the directory is only
> made of numbers.
> raster2pgsql might interpret \419 as a single character or something like
> that.
>
>
> 2015-01-29 15:45 GMT+01:00 Bborie Park <dustymugs at gmail.com>:
>
>> I'm not aware that loading out-db rasters using Windows network path
>> names will work. What happens if you add that network path as a network
>> drive?
>>
>> Can you try something like the following? All I've done is replace the
>> backslash with a forward slash...
>>
>> raster2pgsql -R -a -F  \\\\fileserver/raster/419/napoleonien/*.tif
>> catalog
>>
>> I'm wondering if some escaping rules are getting in the way.
>>
>> On Thu, Jan 29, 2015 at 4:42 AM, Tumasgiu Rossini <rossini.t at gmail.com>
>> wrote:
>>
>>> Hi List,
>>>
>>> I am experiencing a problem with outdb geotiff importation.
>>>
>>> I am using the raster2pgsql utility :
>>>
>>> raster2pgsql -R -a -F  \\fileserver\raster\419\napoleonien\*.tif catalog
>>>
>>> On a particular set of geotiff ( wich are generated with the same
>>> routine as the others ), the command seems to work fine
>>> but St_BandPath() output null when I'm trying to register the tiffs on a
>>> local server, and it output the character  'ô' on the production server.
>>>
>>> On others set of raster, the band path is correctly stored.
>>>
>>> What am I doing wrong ?
>>>
>>>
>>>
>>> My configuration is the following :
>>> Both Local and server ->
>>>    PostgreSQL 9.3.5 installed with EntrepriseDB
>>>    Postgis "2.1 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"
>>>    Win 7 64bit
>>> "French_France.1252"
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150129/7e0aeec1/attachment.html>