| From: | Jeff Davis <pgsql(at)j-davis(dot)com> | 
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org | 
| Subject: | Re: operator exclusion constraints | 
| Date: | 2009-10-25 19:34:09 | 
| Message-ID: | 1256499249.12775.20.camel@jdavis | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
Here's another WIP patch for operator exclusion constraints (both
patches are the same, but one is a context diff made with filterdiff).
It's almost done, and the only reason I'm posting this now is because I
see additional work being done for scalable deferred unique checks, and
I'd like to make sure that we're not interfering with eachother.
Completed Items:
 * support for deferred constraints
 * enforce constraint when added to a table with existing data
 * change predicate to be before DEFERRABLE clause, and require
perentheses around predicate expression
 * doc and test updates
 * make LIKE and INHERITS ignore operator exclusion constraints (there
was some discussion that we should make LIKE behave more consistently,
but I think that's for a different patch)
Open Items:
 * psql support
 * pg_dump support
 * prevent altering a column that's part of an exclusion constraint in a
way that might cause the exclusion constraint to be violated
 * self-review before RRR
Regards,
	Jeff Davis
| Attachment | Content-Type | Size | 
|---|---|---|
| operator-exclusion-constraints-20091025.context.patch | text/x-patch | 94.8 KB | 
| operator-exclusion-constraints-20091025.patch.gz | application/x-gzip | 22.8 KB | 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2009-10-25 19:47:45 | Re: Scaling up deferred unique checks and the after trigger queue | 
| Previous Message | 노홍찬 | 2009-10-25 16:37:43 | Re: a question about relkind of RelationData handed over to heap_update function |