Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group