Re: Deparsing rewritten query - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: Deparsing rewritten query
Date
Msg-id 20220202141630.u2uygy3l33r7yfnt@jrouhaud
Whole thread Raw
In response to Re: Deparsing rewritten query  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Deparsing rewritten query  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Hi,

On Tue, Feb 01, 2022 at 08:35:00PM +0100, Pavel Stehule wrote:
> 
> I tested your patch, and it looks so it is working without any problem. All
> tests passed.
> 
> There is just one question. If printalias = true will be active for all
> cases or just with some flag?

Sorry, as I just replied to Bharath I sent the wrong patch.  The new patch has
the same modification with printalias = true though, so I can still answer that
question.  The change is active for all cases, however it's a no-op for any
in-core case, as a query sent by a client should be valid, and thus should have
an alias attached to all subqueries.  It's only different if you call
get_query_def() on the result of pg_analyze_and_rewrite(), since this code
doesn't add the subquery aliases as those aren't needed for the execution part.



pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Deparsing rewritten query
Next
From: Daniel Gustafsson
Date:
Subject: Ensure that STDERR is empty during connect_ok