Postgres Pro
Downloads
Home   >   mailing lists

Re: CHECK constraint (true) causes dumps with parse errors - Mailing list pgsql-bugs

From Tom Lane
Subject Re: CHECK constraint (true) causes dumps with parse errors
Date
Msg-id 25145.1116603605@sss.pgh.pa.us
Whole thread Raw
In response to Re: CHECK constraint (true) causes dumps with parse errors  (Neil Conway <neilc@samurai.com>)
Responses Re: CHECK constraint (true) causes dumps with parse errors  (Gábor SZŰCS <surrano@gmail.com>)
List pgsql-bugs
Tree view 
Neil Conway <neilc@samurai.com> writes:
> Szűcs Gábor wrote:
>> Check constraints:
>> "foobar" CHECK ()

> Yeah, I can repro this with current REL7_4_STABLE sources, but it looks
> fixed in HEAD and REL8_0_STABLE.

I think the reason is that 7.4 applies make_ands_implicit before storing
the constraint, while 8.0 and up don't.  I'm inclined to think it's not
worth trying to fix in the back branches.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Olleg Samoylov
Date:
Subject: Re: BUG #1676: Statment order in rules
Next
From: Andrew - Supernews
Date:
Subject: Re: initdb fails on ultra2 sparc64, freebsd 5.4