Skip site navigation (1) Skip section navigation (2)

Re: operator exclusion constraints

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 (view raw, whole thread or download thread mbox)
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

	Jeff Davis

Attachment: operator-exclusion-constraints-20091025.context.patch
Description: text/x-patch (94.8 KB)
Attachment: operator-exclusion-constraints-20091025.patch.gz
Description: application/x-gzip (22.8 KB)

In response to


pgsql-hackers by date

Next:From: Jeff DavisDate: 2009-10-25 19:47:45
Subject: Re: Scaling up deferred unique checks and the after trigger queue
Previous:From: 노홍찬Date: 2009-10-25 16:37:43
Subject: Re: a question about relkind of RelationData handed over to heap_update function

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group