Re: operator exclusion constraints

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: operator exclusion constraints
Date: 2009-11-02 08:25:22
Message-ID: 1257150322.14872.4.camel@fsopti579.F-Secure.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 2009-11-01 at 22:42 +0000, Simon Riggs wrote:
> The current patch writes the syntax like this
> EXCLUSION USING gist (c CHECK WITH &&)
> makes it look like a table constraint, yet it clearly refers to a
> single
> column. That looks very clumsy to read, to my eyes.

I think the word CHECK should be avoided completely in this syntax, to
avoid confusion with CHECK constraints.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2009-11-02 09:12:33 Re: Proposal - temporal contrib module
Previous Message Itagaki Takahiro 2009-11-02 07:55:59 Re: CREATE TABLE ... INHERITS (parent INCLUDING xxx)