Opened 9 years ago

Closed 9 years ago

#3070 closed enhancement (fixed)

Simplify geometry type constraint

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.2.0
Component: postgis Version: master
Keywords: Cc:


According to Andrew Gierth we're putting a superfluous condition in our geometry type constraint:

To be removed (doesn't really need to be backported)

BTW, we do not add the superfluous condition in the dimension or srid constraints…

Change History (3)

comment:1 by strk, 9 years ago

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)

comment:2 by strk, 9 years ago

Owner: changed from pramsey to strk
Status: newassigned

comment:3 by strk, 9 years ago

Resolution: fixed
Status: assignedclosed

r13316 in trunk (2.2.0)

Note: See TracTickets for help on using tickets.