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

From Alvaro Herrera
Subject Re: Supporting MERGE on updatable views
Date
Msg-id 202402290950.dgihici7owpx@alvherre.pgsql
Whole thread Raw
In response to Re: Supporting MERGE on updatable views  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: Supporting MERGE on updatable views
List pgsql-hackers
On 2024-Feb-29, Dean Rasheed wrote:

> Going over this again, I spotted a bug -- the UPDATE path in
> ExecMergeMatched() wasn't calling ExecUpdateEpilogue() for
> trigger-updatable views, because it wasn't setting updateCxt.updated
> to true.  (This matters if you have an auto-updatable view WITH CHECK
> OPTION on top of a trigger-updatable view,

Oh, right ... glad you found that.  It sounds a bit convoluted and it
would have been a pain if users had found out afterwards.

> [...], so I've added a new test there.)

Great, thanks.

> Rather than setting updateCxt.updated to true, making the
> trigger-invoking code in ExecMergeMatched() diverge from ExecUpdate(),
> a better fix is to simply remove the UpdateContext.updated flag
> entirely. The only place that reads it is this code in
> ExecMergeMatched():
> 
>     if (result == TM_Ok && updateCxt.updated)
>     {
>         ExecUpdateEpilogue(context, &updateCxt, resultRelInfo,
>                            tupleid, NULL, newslot);
> 
> where result is the result from ExecUpdateAct(). However, all paths
> through ExecUpdateAct() that return TM_Ok also set updateCxt.updated
> to true, so the flag is redundant. It looks like that has always been
> the case, ever since it was introduced. Getting rid of it is a useful
> simplification, and brings the UPDATE path in ExecMergeMatched() more
> into line with ExecUpdate(), which always calls ExecUpdateEpilogue()
> if ExecUpdateAct() returns TM_Ok.

This is a great find!  I agree with getting rid of
UpdateContext->updated as a separate commit.

> Aside from that, I've done a little more copy-editing and added a few
> more test cases, and I think this is pretty-much good to go, though I
> think I'll split this up into separate commits, since removing
> UpdateContext.updated isn't really related to the MERGE INTO view
> feature.

By all means let's get the feature out there.  It's not a frequently
requested thing but it does seem to come up.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Tiene valor aquel que admite que es un cobarde" (Fernandel)



pgsql-hackers by date:

Previous
From: a.imamov@postgrespro.ru
Date:
Subject: Re: Potential issue in ecpg-informix decimal converting functions
Next
From: Amit Kapila
Date:
Subject: Re: Synchronizing slots from primary to standby