[postgis-tickets] [PostGIS] #3070: Simplify geometry type constraint

PostGIS trac at osgeo.org
Thu Mar 5 09:59:48 PST 2015


#3070: Simplify geometry type constraint
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.2.0
Component:  postgis      |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by strk):

 NOTE: removing the "or IS NULL" condition works around a limitation of
 PostgreSQL that makes it unable to use table constraint to skip scan of
 tables with an upfront check (subject of the linked thread)

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


More information about the postgis-tickets mailing list