Re: operator exclusion constraints

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: operator exclusion constraints
Date: 2010-03-11 19:00:59
Message-ID: 1268334059.4899.113.camel@monkey-cat.sm.truviso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-03-11 19:10:16 Re: Server crash with older tzload library
Previous Message Tom Lane 2010-03-11 18:49:15 Re: Server crash with older tzload library