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: 2023-07-02T10:29:29Z

Lists: pgsql-hackers

Attachments

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

On Sun, 19 Mar 2023 at 09:11, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> And another rebase.
>

Rebased version attached.

Aside from a little minor tidying up, I have renamed the new field on
the Query to "mergeTargetRelation", which is a little more consistent
with the naming of existing fields, and with the "mergeSourceRelation"
field that the "WHEN NOT MATCHED BY SOURCE" patch adds.

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