Skip to content
This repository has been archived by the owner on Feb 7, 2019. It is now read-only.

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

Open
brki opened this issue Apr 22, 2015 · 0 comments

Comments

@brki
Copy link
Contributor

brki commented Apr 22, 2015

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).

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant