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

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: assam258(at)gmail(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ayush Tiwari <ayushtiwari(dot)slg01(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-22 13:55:49
Message-ID: CAEZATCWJX0WHGx4WjWACyi_kwzLEpeFcsd8ZuOVsdhijANdgZQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 22 Oct 2026 at 14:39, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> wrote:
>
> Printing "y.a, old.a, t.b" isn't perfect either, because "old" is the
> alias the query author gave to the view

Another option would be to print "y.a, OLD.a, t.b". Putting "OLD" in
capitals, without double-quotes, makes it clear that it's a special
keyword, and it can't clash with a table alias, because a capitalised
table alias would be double-quoted.

Regards,
Dean

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Burd 2026-10-22 13:57:03 Re: [PATCH]Fix planner's strictness check for JsonExpr
Previous Message Fujii Masao 2026-10-22 13:55:08 Re: [PATCH] Remove unused PageIsPredicateLocked()