Horton

Re: possible proposal plpgsql GET DIAGNOSTICS oid = PG_ROUTINE_OID

Pavel Stehule <pavel.stehule@gmail.com>

View thread View on postgr.es
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kirk Wolak <wolakk@gmail.com>, Julien Rouhaud <rjuju123@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-04-04T17:41:53Z
Lists: pgsql-hackers 
út 4. 4. 2023 v 19:34 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:

> Pavel Stehule <pavel.stehule@gmail.com> writes:
> > út 4. 4. 2023 v 16:20 odesílatel Tom Lane <tgl@sss.pgh.pa.us> napsal:
> >> If we do that, then the confusion you were concerned about upthread
> >> goes away and we could shorten the keyword back down to
> "pg_routine_oid",
> >> which seems like a good thing for our carpal tunnels.
>
> > has sense
>
> OK, pushed like that with some cosmetic adjustments (better test
> case, mostly).
>

Thank you very much

Regards

Pavel


>
>                         regards, tom lane
>

Commits

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