Re: Extending outfuncs support to utility statements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Extending outfuncs support to utility statements
Date
Msg-id 1078368.1657548997@sss.pgh.pa.us
Whole thread Raw
In response to Re: Extending outfuncs support to utility statements  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: Extending outfuncs support to utility statements
List pgsql-hackers
Peter Eisentraut <peter.eisentraut@enterprisedb.com> writes:
> On 10.07.22 00:20, Tom Lane wrote:
>> We've long avoided building I/O support for utility-statement node
>> types, mainly because it didn't seem worth the trouble to write and
>> maintain such code by hand.
k
> This is also needed to be able to store utility statements in (unquoted) 
> SQL function bodies.  I have some in-progress code for that that I need 
> to dust off.  IIRC, there are still some nontrivial issues to work 
> through on the reading side.  I don't have a problem with enabling the 
> outfuncs side in the meantime.

Oh!  I'd not thought of that, but yes that is a plausible near-term
requirement for readfuncs support for utility statements.  So my
concern about suppressing those is largely a waste of effort.

There might be enough node types that are raw-parse-tree-only,
but not involved in utility statements, to make it worth
continuing to suppress readfuncs support for them.  But I kinda
doubt it.  I'll try to get some numbers later today.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Making CallContext and InlineCodeBlock less special-case-y
Next
From: Ranier Vilela
Date:
Subject: Re: Reducing Memory Consumption (aset and generation)