Opened 5 years ago

Closed 5 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: trunk
Keywords: Cc:

Description

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

http://www.postgresql.org/message-id/87bnk7z9h6.fsf@news-spur.riddles.org.uk

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 Changed 5 years ago 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)

comment:2 Changed 5 years ago by strk

Owner: changed from pramsey to strk
Status: newassigned

comment:3 Changed 5 years ago by strk

Resolution: fixed
Status: assignedclosed

r13316 in trunk (2.2.0)

Note: See TracTickets for help on using tickets.