Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source
Date
Msg-id CAKFQuwZvf9P4Z1Qv5dv0Crx6QyZfSdEu13HFn+taKymwemMgUQ@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>)
List pgsql-bugs
Tree view
On Tuesday, September 17, 2024, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Ping again as a Reddit poster just pointed this out.

Huh?  The patch you're replying to was committed two years ago.


The patch I’m replying to doesn’t fix the bug reported on this thread though…which still exists.


             CASE WHEN pg_has_role(p.proowner, 'USAGE') THEN p.prosrc ELSE null END
             AS character_data) AS routine_definition,

David J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: INFORMATION_SCHEMA.routines column routine_definition does not show the source
Next
From: PG Bug reporting form
Date:
Subject: BUG #18622: Attempt to grant role in absence of INHERIT option fails with internal error