cleanerversion icon indicating copy to clipboard operation
cleanerversion copied to clipboard

postgresql: add helper to allow ensuring no identity + validity period overlap

Open brki opened this issue 9 years ago • 0 comments

Create an exclusion constraint for version_start_date and version_end_date for objects with the same identity. ( see http://www.postgresql.org/docs/9.3/static/rangetypes.html#RANGETYPES-CONSTRAINT).

This will only be usable if the btree_gist postgresql extension is installed (this requires superuser permissions to install).

brki avatar Apr 22 '15 15:04 brki