Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#1646 closed defect (invalid)

[raster] Unable to add the overview constraint

Reported by: aperi2007 Owned by: pracine
Priority: medium Milestone: PostGIS 2.0.0
Component: raster Version: master
Keywords: Cc:

Description

Hi, using this settings:

raster2pgsql -s 3003 -l 3 -C -e -Y -I -M rst10k_flat/*.tif -F -f rast -d -t 100x100 raster.ctr10k > ctr10k.sql

psql -d archivi -U username -f ctr10k.sql

I try to load a set of raster black/white TIFF4 on a schema called "raster" and on a table named "ctr10k". The schena was empty before to execute the psql, and the BAll seem to go ok, but after the analyze session, I see some warnings

like this:

....
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: NOTICE:  Unable to add constraint "enforce_same_alignment_rast"
CONTEXT: funzione PL/pgSQL "_add_raster_constraint_alignment" linea 29 a RETURN
funzione PL/pgSQL "addrasterconstraints" linea 82 a assegnazione
funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: WARNING:  Unable to add constraint: 'same_alignment'.  Skipping
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: NOTICE:  Adding number of bands constraint
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: NOTICE:  Adding pixel type constraint
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: NOTICE:  Adding nodata value constraint
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: NOTICE:  Adding out-of-database constraint
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: NOTICE:  Adding maximum extent constraint
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: NOTICE:  Unable to get the extent of a sample raster
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 100 a assegnazione
funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
psql:ctr10k.sql:12078772: WARNING:  Unable to add constraint: 'extent'.  Skipping
CONTEXT: funzione PL/pgSQL "addrasterconstraints" linea 53 a RETURN
 addrasterconstraints
----------------------
 t
(1 riga)

....

and at the end I see this error:

psql:ctr10k.sql:12078774: 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:ctr10k.sql:12078774: ERROR:  Unable to add the overview constraint.  Is the schema name, table name or column name incorrect?
VACUUM
VACUUM


I don't understand the message: psql:ctr10k.sql:12078774: ERROR: Unable to add the overview constraint. Is the schema name, table name or column name incorrect?

I don't understant really this message, because see-ing the schema with pgadmin I can see the ctr10k table and the o_3_ctr10k are both available.

Change History (4)

comment:1 by aperi2007, 12 years ago

I'm doing some more test… To better undestand this error.

comment:2 by aperi2007, 12 years ago

I tried using the user owner of the schema "raster". But the error is again here. Now I try using the "postgres" user. I hope it is a problem of grants.

comment:3 by aperi2007, 12 years ago

Resolution: invalid
Status: newclosed

Hi,

using the user "postgres" the error was disappeared.

Seem the only user able to load a raster is the postgres user. I guess the load of rasters should able to other users oyher than postgres, but I don't know actually the grants need to do this.

comment:4 by pracine, 12 years ago

Summary: Raster: Unable to add the overview constraint[raster] Unable to add the overview constraint
Note: See TracTickets for help on using tickets.