[postgis-users] problem with raster2pgsql

Bborie Park bkpark at ucdavis.edu
Fri Mar 9 10:55:27 PST 2012

It'd be nice to get rid of the "rid" column requirement as I never keep 
the "rid" column.  Probably something that searches for a primary or 
unique key...


On 03/09/2012 10:44 AM, Pierre Racine wrote:
>> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

Bborie Park
Center for Vectorborne Diseases
UC Davis
bkpark at ucdavis.edu

More information about the postgis-users mailing list