Re: Supporting MERGE on updatable views - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: Supporting MERGE on updatable views
Date
Msg-id CAEZATCWaObw0viFYGURDt3qLt7TjJk+M1xNa30GdeuJPF8_3EA@mail.gmail.com
Whole thread Raw
In response to Supporting MERGE on updatable views  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Supporting MERGE on updatable views  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-hackers
On Thu, 8 Dec 2022 at 10:03, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> Attached is a WIP patch, which I'll add to the next CF. I still need
> to do more testing, and update the docs, but so far, everything
> appears to work.
>

New patch attached with doc updates and a few other, mostly cosmetic, changes.

One notable change is that I realised that the check for rules on the
target table needs to be done in the rewriter, rather than the parser,
in case expanding a view hierarchy leads to base relations with rules
that the parser wouldn't notice.

Regards,
Dean

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Array initialisation notation in syscache.c
Next
From: David Rowley
Date:
Subject: Re: assertion failures on BuildFarm that happened in slab.c