INFORMATION_SCHEMA.routines column routine_definition does not show the source - Mailing list pgsql-bugs

From David G. Johnston
Subject INFORMATION_SCHEMA.routines column routine_definition does not show the source
Date
Msg-id CAKFQuwYjULC9cUgC_whSsJZ0a4=7naNLMcws1_TJPHSOLFw57Q@mail.gmail.com
Whole thread Raw
In response to Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source
List pgsql-bugs
Ping again as a Reddit poster just pointed this out.

On Thursday, December 1, 2022, Tom Lane <tgl@sss.pgh.pa.us> wrote:
I wrote:
> We could partially fix that by teaching psql to also recognize
> "BEGIN" as the start of the function body.

Looks like we need "RETURN " too, so more or less as attached.

(I didn't bother with a test case yet.  \sf wouldn't be too
hard to exercise, but I wonder how we could test \ef portably.)                


Not sure I bring much to patch review here; but is the plan to commit this first then update information_schema or do both in one go?

David J.

pgsql-bugs by date:

Previous
From: Noah Misch
Date:
Subject: Re: Leader backend hang on IPC/ParallelFinish when LWLock held at parallel query start
Next
From: Tom Lane
Date:
Subject: Re: Leader backend hang on IPC/ParallelFinish when LWLock held at parallel query start