Обсуждение: Re: Is there a way to get the name of the calling function in pgplsql?
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
https://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-CALL-STACK
Regards
Pavel
Kind regards
Thiemo
--
Öffentlicher PGP-Schlüssel: http://pgp.mit.edu/pks/lookup?op=get&search=0x8F70EFD2D972CB EF
------------------------------------------------------------ ----
This message was sent using IMP, the Internet Messaging Program.
Hi all In a function I would like to log the caller. Is there a way to get its name in pgplsql? 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.
Re: Is there a way to get the name of the calling function inpgplsql?
От
"Thiemo Kellner, NHC Barhufpflege"
Дата:
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&search=0x8F70EFD2D972CBEF ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.
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
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=0x8F70EFD2D972CB EF
------------------------------------------------------------ ----
This message was sent using IMP, the Internet Messaging Program.