[gdal-dev] gdal 3.11 vector pipeline with postgres problems

[Richard Greenwood]

Below works:
*$ gdal vector info PG:"$PGCONN" -l "roads"*

And this works:
*$ gdal vector convert PG:"$PGCONN" -l "roads" junk*

But below fails (I'm using pipeline because I need an intermediate step
once I get this to work). I do not have the postgis_raster extension in
this database.




*$ gdal vector pipeline read PG:"$PGCONN" -l "roads" ! write junkERROR 1:
Error browsing database for PostGIS Raster tables: ERROR 1: Error browsing
database for PostGIS Raster tables: Usage: gdal vector pipeline [OPTIONS]
<PIPELINE>Try 'gdal vector pipeline --help' for help.*

I created the postgis_raster extension and ran the same pipeline:

*$ gdal vector pipeline read PG:"$PGCONN" -l "roads" ! write junkERROR 1:
read: Cannot find source layer 'roads'*

It seems like requiring the postgis_raster extension is a bug.
What about the *Cannot find source layer*? I fiddled with specifying the
schema, different quoting, etc.

Thanks
--
Richard W. Greenwood
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20250426/59d65c92/attachment.htm>