Re: CHECK constraint (true) causes dumps with parse errors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Szűcs Gábor <surrano(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: CHECK constraint (true) causes dumps with parse errors
Date: 2005-05-20 15:40:05
Message-ID: 25145.1116603605@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Neil Conway <neilc(at)samurai(dot)com> writes:
> Szcs Gbor 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew - Supernews 2005-05-21 04:30:06 Re: initdb fails on ultra2 sparc64, freebsd 5.4
Previous Message Olleg Samoylov 2005-05-20 09:07:32 Re: BUG #1676: Statment order in rules