[postgis-users] problem with raster2pgsql

[Bborie Park]

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...

-bborie

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
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu