[postgis-devel] Exclusion Constraints in PostgreSQL 8.5

Jeff Davis pgsql at j-davis.com
Tue Dec 8 09:54:24 PST 2009

Exclusion Constraints was just committed to PostgreSQL:


I developed this feature for temporal data management (temporal keys,
specifically), but it will work with geometric/geographic data as well.

The most obvious use case regarding PostGIS would be to prevent
overlapping geometries from existing in the same table. However, the
operators all seem to be based on the bounding boxes of the geometries,
not the geometries themselves.

Is there a reason the operators don't use RECHECK? If they did use
RECHECK, PostGIS would work very nicely with Exclusion Constraints right
now. Is PostGIS interested in supporting a set of operators that can be
used with Exclusion Constraints?

	Jeff Davis

More information about the postgis-devel mailing list