Horton

INFORMATION_SCHEMA.routines column routine_definition does not show the source

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

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Erki Eessaar <erki.eessaar@taltech.ee>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2024-09-18T05:42:53Z
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 →

  1. Add some sanity checks in executor for query ID reporting

  2. Fix psql's \sf and \ef for new-style SQL functions.

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.