Re: Fix bug of CHECK constraint enforceability recursion - Mailing list pgsql-hackers

From Zsolt Parragi
Subject Re: Fix bug of CHECK constraint enforceability recursion
Date
Msg-id CAN4CZFOOhDAWdnY1OXB1wfG_=C4g_dw0gC2HCApz_3F7EFpqJA@mail.gmail.com
Whole thread
In response to Re: Fix bug of CHECK constraint enforceability recursion  (Chao Li <li.evan.chao@gmail.com>)
Responses Re: Fix bug of CHECK constraint enforceability recursion
List pgsql-hackers
Hello

After a bit more testing, I think there's still a remaining issue with
the latest patch:

create table root_t (a int constraint c check (a > 0) enforced);
create table p2     (a int constraint c check (a > 0) enforced);
create table d () inherits (root_t, p2);
create table e () inherits (d);
create table f () inherits (e);
alter table root_t alter constraint c not enforced;
insert into e values (-5); -- succeeds

d remains enforced as it should, but e and f doesn't.



pgsql-hackers by date:

Previous
From: Zsolt Parragi
Date:
Subject: Re: alert clients when prepared statements are deallocated
Next
From: Nathan Bossart
Date:
Subject: Re: alert clients when prepared statements are deallocated