From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | possible proposal plpgsql GET DIAGNOSTICS oid = PG_ROUTINE_OID |
Date: | 2023-02-07 19:48:22 |
Message-ID: | CAFj8pRA4zMd5pY-B89Gm64bDLRt-L+akOd34aD1j4PEstHHSVQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
I have a question about the possibility of simply getting the name of the
currently executed function. The reason for this request is simplification
of writing debug messages.
GET DIAGNOSTICS _oid = PG_ROUTINE_OID;
RAISE NOTICE '... % ... %', _oid, _oid::regproc::text;
The advantage of this dynamic access to function name is always valid value
not sensitive to some renaming or moving between schemas.
I am able to separate a name from context, but it can be harder to write
this separation really robustly. It can be very easy to enhance the GET
DIAGNOSTICS statement to return the oid of currently executed function.
Do you think it can be useful feature?
The implementation should be trivial.
Comments, notes?
Regards
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2023-02-07 19:49:03 | Re: Assertion failure in SnapBuildInitialSnapshot() |
Previous Message | Tom Lane | 2023-02-07 18:28:26 | Re: OpenSSL 3.0.0 vs old branches |