[postgis-devel] [PostGIS] #1646: Raster: Unable to add the overview constraint

[PostGIS]

#1646: Raster: Unable to add the overview constraint
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  pracine      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.0
Component:  raster     |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------
 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:[[BR]]


 {{{

 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

 }}}
 [[BR]]

 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.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1646>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.