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

#1

Szűcs Gábor wrote:

Quote:

# create table foo (bar int, constraint foobar check (true));
CREATE TABLE
# \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
bar | integer |
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.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

#2

Neil Conway <neilc (AT) samurai (DOT) com> writes:

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] CHECK constraint (true) causes dumps with parse errors - 05-20-2005 , 03:23 AM

Re: [BUGS] CHECK constraint (true) causes dumps with parse errors - 05-20-2005 , 10:41 AM