Re: [DEPARSE] EXPLAIN prints another ModifyTable's RETURNING aliases in a SubPlan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>, assam258(at)gmail(dot)com, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [DEPARSE] EXPLAIN prints another ModifyTable's RETURNING aliases in a SubPlan
Date: 2026-10-21 21:43:29
Message-ID: 2237072.1792619009@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> writes:
> On Wed, 21 Oct 2026 at 22:15, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> So just to clarify, you now agree with that fix instead of dropping
>> the new Asserts?

> Yes, I'm fine either way actually, because I think it's not
> particularly likely to come up in practice.

Cool, I'll take care of it in a bit. Thanks for the detailed
response.

(If this is in fact rare, and it probably is given that the manual
deprecates RETURNING WITH in rules, then it's likely not worth
the trouble to try to fix the query representation to keep the
aliases separate.)

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message surya poondla 2026-10-21 21:46:00 Re: tablecmds: Deadlock caused by Attach Partition
Previous Message Dean Rasheed 2026-10-21 21:25:36 Re: [DEPARSE] EXPLAIN prints another ModifyTable's RETURNING aliases in a SubPlan