Re: operator exclusion constraints

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: operator exclusion constraints
Дата
Msg-id
1259731114.3355.126.camel@jdavis
Ответ на
Список
Дерево обсуждения
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 Tue, 2009-12-01 at 23:19 -0500, Robert Haas wrote:
> For parity with unique constraints, I think that the message:
> 
> operator exclusion constraint violation detected: %s
> 
> should be changed to:
> 
> conflicting key value violates operator exclusion constraint "%s"

Done, and updated tests.

> In ATAddOperatorExclusionConstraint, "streatagy" is misspelled.

Fixed.

> Other than that, it looks good to me.

Great, thanks for the detailed review!

Regards,
	Jeff Davis
В списке pgsql-hackers по дате отправления
От: KaiGai Kohei
Дата:
Сообщение: Re: SE-PgSQL patch review
От: Tom Lane
Дата:
FAQ