[postgis-tickets] [PostGIS] #2215: [raster] Use of exclusion constraint on multiple tables fails due to name of implicit index (was: [raster] Different constraints set for in-db and out-db)

[PostGIS]

#2215: [raster] Use of exclusion constraint on multiple tables fails due to name
of implicit index
----------------------+-----------------------------------------------------
  Reporter:  mloskot  |       Owner:  dustymugs           
      Type:  defect   |      Status:  closed              
  Priority:  medium   |   Milestone:  PostGIS 2.1.0       
 Component:  raster   |     Version:  trunk               
Resolution:  fixed    |    Keywords:  constraints, history
----------------------+-----------------------------------------------------
Changes (by dustymugs):

  * keywords:  constraints => constraints, history
  * status:  new => closed
  * resolution:  => fixed
  * milestone:  => PostGIS 2.1.0


Comment:

 Fixed in r11117.

 A simplified test case.

 {{{
 CREATE TABLE foo AS
         SELECT
                 id
         FROM generate_series(1, 5) t(id);
 CREATE TABLE bar AS
         SELECT
                 id
         FROM generate_series(1, 5) t(id);
 ALTER TABLE foo
         ADD CONSTRAINT enforce_unique_id EXCLUDE (id WITH =);
 ALTER TABLE bar
         ADD CONSTRAINT enforce_unique_id EXCLUDE (id WITH =);
 }}}

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