Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-04-05 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Tom Lane wrote: Bruce Momjian br...@momjian.us writes: + Exclusion constraints ensure that if any two rows are compared on + the specified columns or expressions using the specified operators, + at least one of these operator comparisons will

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-04-05 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tom Lane wrote: Bruce Momjian br...@momjian.us writes: + Exclusion constraints ensure that if any two rows are compared on + the specified columns or expressions using the specified operators, + at least one of these

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-04-04 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: + Exclusion constraints ensure that if any two rows are compared on + the specified columns or expressions using the specified operators, + at least one of these operator comparisons will be false. The syntax is: Isn't

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-04-01 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: + Exclusion constraints ensure that if any two rows are compared on + the specified columns or expressions using the specified operators, + at least one of these operator comparisons will be false. The syntax is: Isn't that phrasing outright

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Takahiro Itagaki
Robert Haas robertmh...@gmail.com wrote: * (seq_page_cost/(random_page_cost)) * EXCLUDE constraints has no tags to be linked. * EXCLUDE constraints is not indexed from the Index page. CREATE TABLE ... CONSTRAINT ... EXCLUDE rather than CREATE TABLE CONSTRAINT ... EXCLUDE. Here is a

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Thom Brown
On 31 March 2010 07:56, Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: Robert Haas robertmh...@gmail.com wrote: * (seq_page_cost/(random_page_cost)) * EXCLUDE constraints has no tags to be linked. * EXCLUDE constraints is not indexed from the Index page. CREATE TABLE ...

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Robert Haas
On Wed, Mar 31, 2010 at 2:56 AM, Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: Robert Haas robertmh...@gmail.com wrote: * (seq_page_cost/(random_page_cost)) * EXCLUDE constraints has no tags to be linked. * EXCLUDE constraints is not indexed from the Index page. CREATE TABLE

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Kevin Grittner
Robert Haas robertmh...@gmail.com wrote: This says: Exclusion constraints ensure that that if any two rows are compared on the specified column(s) or expression(s) using the specified operator(s), not all of these comparisons will return literalTRUE/. I think that's backwards - the

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Robert Haas
On Wed, Mar 31, 2010 at 1:07 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: This says: Exclusion constraints ensure that that if any two rows are compared on the specified column(s) or expression(s) using the specified operator(s), not all of

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Bruce Momjian
Takahiro Itagaki wrote: Robert Haas robertmh...@gmail.com wrote: * (seq_page_cost/(random_page_cost)) * EXCLUDE constraints has no tags to be linked. * EXCLUDE constraints is not indexed from the Index page. CREATE TABLE ... CONSTRAINT ... EXCLUDE rather than CREATE TABLE

Re: [SPAM]Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Bruce Momjian
Takahiro Itagaki wrote: Robert Haas robertmh...@gmail.com wrote: * (seq_page_cost/(random_page_cost)) * EXCLUDE constraints has no tags to be linked. * EXCLUDE constraints is not indexed from the Index page. CREATE TABLE ... CONSTRAINT ... EXCLUDE rather than CREATE TABLE