Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: "David G. Johnston" <david.g.johnston@gmail.com>

Cc: Erki Eessaar <erki.eessaar@taltech.ee>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>

Date: 2022-12-02T02:41:30Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add some sanity checks in executor for query ID reporting
- 24f520594809 18.0 cited
Fix psql's \sf and \ef for new-style SQL functions.
- cabfb8241dea 16.0 landed
- 97299cf99df0 15.2 landed
- 303b26c1bb14 14.7 landed

Attachments

fix-psql-sf-ef-for-new-style-functions.patch (text/x-diff) patch

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.)

			regards, tom lane