Re: ERROR: too late to create a new PlaceHolderInfo - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ERROR: too late to create a new PlaceHolderInfo
Date
Msg-id 644229.1789659667@sss.pgh.pa.us
Whole thread
In response to Re: ERROR: too late to create a new PlaceHolderInfo  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:
> I agree with that sounding more principled, but I wonder if we should
> think bigger than just tweaking add_nullingrels_if_needed: if we're
> desirous of de-duplicating PHVs, why not do that across the board,
> for every place that makes PHVs?  So we'd mechanize this in
> make_placeholder_expr's assignment of phid rather than somewhere else.

Actually, we can't be too gung-ho about that: we should not merge
PHVs if their expressions are volatile.  It's not quite clear to me
whether that's a problem for the join-alias-Vars case.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] pg_dump: Restore extension config table data before user objects during pg_upgrade
Next
From: Vik Fearing
Date:
Subject: Re: ON EMPTY clause for aggregate and window functions