Re: Supporting MERGE on updatable views

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Supporting MERGE on updatable views
Date: 2022-12-30 12:47:23
Message-ID: CAEZATCWwETjKgCCrZJHyRwOngrM-ytapY5WLvp89eRxmRPxPfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 21 Dec 2022 at 20:04, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)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

Attachment Content-Type Size
support-merge-into-view-v3.patch text/x-patch 122.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-12-30 16:32:53 Re: Removing redundant grouping columns
Previous Message Peter Eisentraut 2022-12-30 11:53:08 Re: split TOAST support out of postgres.h