Add a way to get the current function's OID in pl/pgsql.

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

Commit: d3d53f955cf6ad755ba3682577e0f6fa10106438
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2023-04-04T17:33:18Z
Releases: 16.0
Add a way to get the current function's OID in pl/pgsql.

Invent "GET DIAGNOSTICS oid_variable = PG_ROUTINE_OID".
This is useful for avoiding the maintenance nuisances that come
with embedding a function's name in its body, as one might do
for logging purposes for example.  Typically users would cast the
result to regproc or regprocedure to get something human-readable,
but we won't pre-judge whether that's appropriate.

Pavel Stehule, reviewed by Kirk Wolak and myself

Discussion: https://postgr.es/m/CAFj8pRA4zMd5pY-B89Gm64bDLRt-L+akOd34aD1j4PEstHHSVQ@mail.gmail.com

Files

Documentation touched

Discussion