[postgis-devel] [PostGIS] #1764: overviews not marked as same alignment though main table is

[PostGIS]

#1764: overviews not marked as same alignment though main table is
--------------------+-------------------------------------------------------
 Reporter:  robe    |       Owner:  dustymugs    
     Type:  defect  |      Status:  assigned     
 Priority:  medium  |   Milestone:  PostGIS 2.0.1
Component:  raster  |     Version:  2.0.x        
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by robe):

 I'll send in a bit.  I doesn't seem to happen in the same file.  So you
 have to test at least two files I think.

 I had to run this query to find a candidate:


 {{{
 SELECT v1.filename As v1_filename, o1.rid As o1_rid,  v2.filename As
 v2_filename, o2.rid as o2_rid
 FROM o_3_vhms As o1 INNER JOIN o_3_vhms As o2 ON
 ST_SameAlignment(o1.rast,o2.rast) = false
   INNER JOIN vhms As v1 ON ST_Within(v1.rast::geometry, o1.rast::geometry)
    INNER JOIN vhms As v2 ON ST_Within(v2.rast::geometry,
 o2.rast::geometry)
 limit 1;
 }}}

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