Re: operator exclusion constraints

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: operator exclusion constraints
Дата
Msg-id
603c8f070912031826l541600a6v1e74604836711ee@mail.gmail.com
Ответ на
Список
Дерево обсуждения
WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Simon Riggs <simon@2ndQuadrant.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Simon Riggs <simon@2ndQuadrant.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Simon Riggs <simon@2ndQuadrant.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Simon Riggs <simon@2ndQuadrant.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Greg Stark <gsstark@mit.edu>
Re: WIP: generalized index constraints Dean Rasheed <dean.a.rasheed@googlemail.com>
Re: WIP: generalized index constraints David Fetter <david@fetter.org>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Greg Stark <gsstark@mit.edu>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Greg Stark <gsstark@mit.edu>
Re: WIP: generalized index constraints Greg Stark <gsstark@mit.edu>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Dimitri Fontaine <dfontaine@hi-media.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Alvaro Herrera <alvherre@commandprompt.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Robert Haas <robertmhaas@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Robert Haas <robertmhaas@gmail.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Robert Haas <robertmhaas@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints tomas@tuxteam.de
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints tomas@tuxteam.de
Re: WIP: generalized index constraints Robert Haas <robertmhaas@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints David Fetter <david@fetter.org>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Peter Eisentraut <peter_e@gmx.net>
Re: WIP: generalized index constraints David Fetter <david@fetter.org>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Joshua Tolley <eggyknap@gmail.com>
Re: WIP: generalized index constraints Robert Haas <robertmhaas@gmail.com>
Re: WIP: generalized index constraints Robert Haas <robertmhaas@gmail.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Peter Eisentraut <peter_e@gmx.net>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Robert Haas <robertmhaas@gmail.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Brendan Jurd <direvus@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Joshua Tolley <eggyknap@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints David Fetter <david@fetter.org>
Re: WIP: generalized index constraints Greg Stark <gsstark@mit.edu>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] David Fetter <david@fetter.org>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
Re: WIP: generalized index constraints Peter Eisentraut <peter_e@gmx.net>
Re: WIP: generalized index constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Robert Haas <robertmhaas@gmail.com>
Re: WIP: generalized index constraints Jeff Davis <pgsql@j-davis.com>
operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Simon Riggs <simon@2ndQuadrant.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Simon Riggs <simon@2ndQuadrant.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Peter Eisentraut <peter_e@gmx.net>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Simon Riggs <simon@2ndQuadrant.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Peter Eisentraut <peter_e@gmx.net>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Alvaro Herrera <alvherre@commandprompt.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Simon Riggs <simon@2ndQuadrant.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Greg Stark <gsstark@mit.edu>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Alvaro Herrera <alvherre@commandprompt.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Brendan Jurd <direvus@gmail.com>
Re: operator exclusion constraints Greg Stark <gsstark@mit.edu>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Josh Berkus <josh@agliodbs.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Josh Berkus <josh@agliodbs.com>
Re: operator exclusion constraints David Fetter <david@fetter.org>
Re: operator exclusion constraints Peter Eisentraut <peter_e@gmx.net>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints David Fetter <david@fetter.org>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints tomas@tuxteam.de
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Greg Stark <gsstark@mit.edu>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Dimitri Fontaine <dfontaine@hi-media.com>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Andrew Dunstan <andrew@dunslane.net>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Alvaro Herrera <alvherre@commandprompt.com>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Alvaro Herrera <alvherre@commandprompt.com>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints "David E. Wheeler" <david@kineticode.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Dean Rasheed <dean.a.rasheed@googlemail.com>
Re: operator exclusion constraints Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints Simon Riggs <simon@2ndQuadrant.com>
Re: operator exclusion constraints Nathan Boley <npboley@gmail.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Peter Eisentraut <peter_e@gmx.net>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: operator exclusion constraints [was: generalized index constraints] Robert Haas <robertmhaas@gmail.com>
Re: operator exclusion constraints [was: generalized index constraints] Jeff Davis <pgsql@j-davis.com>
Re: operator exclusion constraints [was: generalized index constraints] Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: generalized index constraints Teodor Sigaev <teodor@sigaev.ru>
On Thu, Dec 3, 2009 at 7:42 PM, Jeff Davis  wrote:
> On Thu, 2009-12-03 at 19:00 -0500, Tom Lane wrote:
>> I'm starting to go through this patch now.  I thought the consensus
>> was to refer to them as just "exclusion constraints"?  I'm not seeing
>> that the word "operator" really adds anything.
>
> I assume you're referring to the name used in documentation and error
> messages. I didn't see a clear consensus, but the relevant thread is
> here:
>
> http://archives.postgresql.org/message-id/1258227283.708.108.camel@jdavis
>
> "Exclusion Constraints" is fine with me, as are the other options listed
> in that email.

Yeah, I don't remember any such consensus either, but it's not a dumb
name.  I have been idly wondering throughout this process whether we
should try to pick a name that conveys the fact that these constraints
are inextricably tied to the opclass/index machinery - but I'm not
sure it's possible to really give that flavor in a short phrase, or
that it's actually important to do so.  IOW... "whatever".  :-)

...Robert

В списке pgsql-hackers по дате отправления
От: David E. Wheeler
Дата:
Сообщение: Format Typmod?
От: Itagaki Takahiro
Дата:
Сообщение: Re: Syntax for partitioning
FAQ