Re: PostgreSQL Rule does not work with deferred constraint.

2022-09-21 Thread Tom Lane
Laurenz Albe writes: > I just tried your commands, and it works as you expect on my PostgreSQL v15 > database. It does fail for me, but I think it's a well-known trap rather than a bug (or at least, it's not something that anyone wishes to redesign the rule system to change). The problem is tha

Re: PostgreSQL Rule does not work with deferred constraint.

2022-09-21 Thread Laurenz Albe
On Wed, 2022-09-21 at 01:19 +, Louis Tian wrote: > Encountered a possible bug today. In short, it appears that the rule system > is not deferring the constraint checking as specified. Here is an example. > > create table "parent" ( > >   "id" uuid primary key > > ); > > > > create table "chil