Re: Is there a way to get the name of the calling function in pgplsql?

Started by Pavel Stehuleabout 8 years ago3 messagesgeneral
Jump to latest
#1Pavel Stehule
pavel.stehule@gmail.com

Hi

2018-03-21 8:24 GMT+01:00 Thiemo Kellner <thiemo@gelassene-pferde.biz>:

Hi all

In a function I would like to log the caller. Is there a way to get its
name in pgplsql?

you can read it from stack

https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-CALL-STACK

Regards

Pavel

Show quoted text

Kind regards

Thiemo

--
Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup?
op=get&search=0x8F70EFD2D972CBEF

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

#2Thiemo Kellner, NHC Barhufpflege
thiemo.kellner@gelassene-pferde.biz
In reply to: Pavel Stehule (#1)

Thanks for the hint and please excuse my not thouroughly enough
reading of the documentation. I did not suspect such Feature amongst
controll structures.

Zitat von Pavel Stehule <pavel.stehule@gmail.com>:

https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-CALL-STACK

--
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&amp;search=0x8F70EFD2D972CBEF

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Thiemo Kellner, NHC Barhufpflege (#2)

2018-03-21 13:30 GMT+01:00 Thiemo Kellner, NHC Barhufpflege <
thiemo.kellner@gelassene-pferde.biz>:

Thanks for the hint and please excuse my not thouroughly enough reading of
the documentation. I did not suspect such Feature amongst controll
structures.

no problem:)

Pavel

Show quoted text

Zitat von Pavel Stehule <pavel.stehule@gmail.com>:

https://www.postgresql.org/docs/current/static/plpgsql-contr

ol-structures.html#PLPGSQL-CALL-STACK

--
Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup?
op=get&search=0x8F70EFD2D972CBEF

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.