Re: Supporting MERGE on updatable views

Dean Rasheed <dean.a.rasheed@gmail.com>

From: Dean Rasheed <dean.a.rasheed@gmail.com>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2022-12-30T12:47:23Z

Lists: pgsql-hackers

Attachments

support-merge-into-view-v3.patch (text/x-patch) patch v3

On Wed, 21 Dec 2022 at 20:04, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> New patch attached with doc updates and a few other, mostly cosmetic, changes.
>

New version fixing a bug in preprocess_targetlist() -- given a simple
auto-updatable view that also has INSTEAD OF triggers, subquery pullup
of the target may produce PlaceHolderVars in MERGE WHEN clauses, which
the former code wasn't expecting to find.

Regards,
Dean

Commits

Support MERGE into updatable views.
- 5f2e179bd31e 17.0 landed
Remove field UpdateContext->updated in nodeModifyTable.c
- 362de947cd7e 17.0 landed
Remove dummy_spinlock
- 55627ba2d334 17.0 cited