On 12/26/23 22:41, Kirk Wolak wrote:
On Mon, Dec 25, 2023 at 1:47 PM Christophe Pettus <xof@xxxxxxxxxxxx
<mailto:xof@xxxxxxxxxxxx>> wrote:
> On Dec 25, 2023, at 10:44, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
> Functions with same name in different schemas would need to be
dealt with.
I think that's the primary use-case (at least, it would be for me),
and I don't see a convenient way of doing that. Even a "get OID of
current function" function would be useful here.
And Pavel Already Created it:
GET DIAGNOSTIC PID = PG_ROUTINE_OID ;
To be clear the above is for Postgres 16+ and for the plpgsql language only.
If I understand the issue correctly.
Kirk Out!
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx