Skip to main content

I'm trying to read raster data from postGIS using the 'PostGIS Raster' FeatureReader and keep getting an error about band metadata. However, I can load in the same raster data OK via a select statement in a SQLExecutor transformer. The rasters in question only have one band, but I don't imagine that should be an issue.

 

As the data returned via the SQLExecutor look fine, I'm assuming that there is nothing wrong with the data in postGIS, but the error is making me question that...

 

The error I'm getting is;

2022-03-30 15:46:00|  0.2| 0.0|ERROR |Error executing SQL command 

 ('SELECT ST_BandMetaData("rast",1), to_char(ST_BandNoDataValue("rast",1),'9.9999999999999999EEEE') FROM "schema"."table" WHERE "pk_index" = '1'')

 :'ERROR: table-function protocol for value-per-call mode was not followed

 CONTEXT: SQL function "st_bandmetadata" statement 1'

 

Any thoughts or help much appreciated

Matt

Be the first to reply!

Reply