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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CHECK constraint (true) causes dumps with parse errors
Дата
Msg-id 25145.1116603605@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CHECK constraint (true) causes dumps with parse errors  (Neil Conway <neilc@samurai.com>)
Ответы Re: CHECK constraint (true) causes dumps with parse errors  (Gábor SZŰCS <surrano@gmail.com>)
Список pgsql-bugs
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 по дате отправления:

Предыдущее
От: Olleg Samoylov
Дата:
Сообщение: Re: BUG #1676: Statment order in rules
Следующее
От: Andrew - Supernews
Дата:
Сообщение: Re: initdb fails on ultra2 sparc64, freebsd 5.4