[postgis-tickets] [PostGIS] #2143: [raster] Width and Height column of raster_columns view may need changing

[PostGIS]

#2143: [raster] Width and Height column of raster_columns view may need changing
-------------------------+--------------------------------------------------
 Reporter:  dustymugs    |       Owner:  dustymugs    
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.1.0
Component:  raster       |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by dustymugs):

 Your algo is flawed in step 2.  There is no way to access an index.  As
 per PostgreSQL's docs:

 [http://www.postgresql.org/docs/9.0/static/sql-createtable.html]

   Currently, CHECK expressions cannot contain subqueries nor refer to
 variables other than columns of the current row.

 Additionally, any access to an index requires knowing the names of the
 table and column you're dealing with.  You won't know that in a CHECK
 constraint.  Sure, you could hard code the names in... but that fails you
 the moment you need to change the table or column name.

 There also is NO way to determine what value to put into the
 raster_columns view from that algo.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2143#comment:3>
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.