Log In - Home Page

Patch: Operator Exclusion Constraints (was: Generalized Index Constraints)

Edit Patch - Move To Another CommitFest - Delete Patch

CommitFest 2009-11
Topic Miscellaneous
Patch Status Committed
Author Jeff Davis
Reviewers Robert Haas
Committer Tom Lane
Close Date 2009-12-06
Patch by jdavis on 2009-10-25 02:00:12 PM: Initial version.
Patch by jdavis on 2009-10-25 02:01:58 PM: Implemented all significant changes to language and semantics discussed. Nearly complete.
Comment by jdavis on 2009-10-27 11:22:13 PM: Dean Rasheed found concurrency problem
Patch by jdavis on 2009-10-27 11:24:05 PM: Patch fixes problem found by Dean Rasheed
Patch by jdavis on 2009-11-01 01:14:23 PM: All open items completed. Ready for review.
Comment by jdavis on 2009-11-07 01:13:33 PM: Need to avoid keywords unless they are col_name_keyword or unreserved.
Patch by jdavis on 2009-11-07 01:14:58 PM: Make changes suggested by Tom: EXCLUSION is now an unreserved keyword.
Patch by jdavis on 2009-11-08 03:59:51 PM: Change EXCLUSION syntax to EXCLUDE, per discussion.
Review by rhaas on 2009-11-13 11:03:56 PM: initial, cursory review; more detailed review to follow
Patch by jdavis on 2009-11-14 01:45:23 PM: Addressed most of the issues in initial review, changed CHECK WITH to WITH.
Comment by jdavis on 2009-11-18 02:59:19 PM: Some suggestions by Robert Haas
Comment by jdavis on 2009-11-18 03:01:47 PM: Josh Berkus suggests using UNIQUE violation for the SQLSTATE of the error.
Comment by jdavis on 2009-11-18 03:05:44 PM: What should the docs and error messages use for the full name?
Comment by jdavis on 2009-11-20 10:10:49 PM: Josh Berkus suggests a new SQLSTATE.
Patch by jdavis on 2009-11-25 02:45:35 AM: Be more lenient in accepting operators when the types don't match exactly (e.g. anyarray). Also, add new SQLSTATE.
Patch by jdavis on 2009-11-26 01:50:55 PM: Improve docs and error messages.
Patch by jdavis on 2009-11-27 09:38:51 PM: All open issues closed.
Patch by jdavis on 2009-12-01 11:41:36 PM: Error message changed to be more like UNIQUE, and minor cleanup. All open issues closed.

Add Comment

Please log in to comment on this patch.