summaryrefslogtreecommitdiff
path: root/src/backend/commands/constraint.c
Commit message (Collapse)AuthorAgeFilesLines
* Add exclusion constraints, which generalize the concept of uniqueness toTom Lane2009-12-071-11/+34
| | | | | | | | support any indexable commutative operator, not just equality. Two rows violate the exclusion constraint if "row1.col OP row2.col" is TRUE for each of the columns in the constraint. Jeff Davis, reviewed by Robert Haas
* Support deferrable uniqueness constraints.Tom Lane2009-07-291-0/+166
The current implementation fires an AFTER ROW trigger for each tuple that looks like it might be non-unique according to the index contents at the time of insertion. This works well as long as there aren't many conflicts, but won't scale to massive unique-key reassignments. Improving that case is a TODO item. Dean Rasheed