[postgis-users] Adding raster overviews

Bborie Park bkpark at ucdavis.edu
Tue Dec 4 11:58:03 PST 2012

Hey Paolo,

That ticket indicated that user didn't have the necessary privileges for
adding that constraint.  Once he used an account with the necessary
privileges, the error went away.

I can't provide more advice without knowing how you're calling
raster2pgsql and psql.


On 12/04/2012 11:53 AM, Paolo Cavallini wrote:
> Hi all.
> I just came across to an old issue:
> http://trac.osgeo.org/postgis/ticket/1646
> In practice, option -l in raster2pgsql results in:
> ...
> psql:dtm_tiled.sql:1468: NOTICE:  Unable to add constraint "enforce_overview_rast"
> CONTEXT: funzione PL/pgSQL "_add_overview_constraint" linea 24 a RETURN
> funzione PL/pgSQL "addoverviewconstraints" linea 61 a assegnazione
> psql:dtm_tiled.sql:1468: ERROR:  Unable to add the overview constraint.  Is the
> schema name, table name or column name incorrect?
> ...
> Anything wrong?
> PostGIS 2.0.2, GDAL 1.9.0
> Thanks.

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

More information about the postgis-users mailing list