Re: Removing unneeded self joins - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: Removing unneeded self joins
Date
Msg-id CAPpHfdtTxSs+t8PXjJ_EC5roaQRLPyxt71M=AJvrGjYFC-wK5g@mail.gmail.com
Whole thread Raw
In response to Re: Removing unneeded self joins  (Ranier Vilela <ranier.vf@gmail.com>)
Responses Re: Removing unneeded self joins
List pgsql-hackers
Hi all,

I've got an off-list bug report from Alexander Lakhin involving a
placeholder variable.  Alena and Andrei proposed a fix.  It is fairly
simple: we just shouldn't remove PHVs during self-join elimination, as
they might still be referenced from other parts of a query.  The patch
is attached.  I'm going to fix this if no objections.

------
Regards,
Alexander Korotkov
Supabase

Attachment

pgsql-hackers by date:

Previous
From: Sami Imseih
Date:
Subject: rename pg_log_standby_snapshot
Next
From: Ranier Vilela
Date:
Subject: Re: AIO v2.5