Horton
Menu

Re: operator exclusion constraints

Jeff Davis <pgsql@j-davis.com>

View thread
From: Jeff Davis <pgsql@j-davis.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@postgreSQL.org
Date: 2010-03-11T19:00:59Z
Lists: pgsql-hackers 
On Thu, 2010-03-11 at 00:29 -0500, Tom Lane wrote:

Patch changes:

> > Indexes:
> >     "foo_pkey" PRIMARY KEY, btree (f1), tablespace "ts1"
> >     "foo_f2_exclusion" btree (f2), tablespace "ts1"
> >     "foo_f3_exclusion" btree (f3) DEFERRABLE INITIALLY DEFERRED
> > Exclusion constraints:
> >     "foo_f2_exclusion" EXCLUDE USING btree (f2 WITH =)
> >     "foo_f3_exclusion" EXCLUDE USING btree (f3 WITH =) DEFERRABLE INITIALLY DEFERRED

To:

> Indexes:
>     "foo_pkey" PRIMARY KEY, btree (f1), tablespace "ts1"
>     "foo_f2_exclusion" EXCLUDE USING btree (f2 WITH =), tablespace "ts1"
>     "foo_f3_exclusion" EXCLUDE USING btree (f3 WITH =) DEFERRABLE INITIALLY DEFERRED
> 
> Any objections?

Looks good to me.

Regards,
	Jeff Davis