[postgis-users] problem with raster2pgsql

[Pierre Racine]

> Correct.  GDAL 1.9 works fine as long as the table has a rid column.
> rtpostgis_legacy.sql is not needed.

I guess, looking at the queries the driver is doing, that it is not able to select the best overview when rtpostgis_legacy.sql is not installed. Otherwise, if no specific overview is requested, it works fine with just the rid. This might explain why it fails with QGIS which is requesting for specific overviews. I have to test more.

So rules:

If using GDAL, just make sure to have a "rid" column.

If using QGIS, install rtpostgis_legacy.sql AND make sure to have a "rid" column

Pierre