How to find out who is calling the function

[BARTKO Zoltan]

Dear friends,

I had a look at www.pgsql.ru, looking for how to find out what user is calling the function - from inside the function. No luck.

Could someone enlighten me:

I have a stored function. I want to do the following:

if caller() = ''userA'' then
return -1; -- error
else
return 0;
end if; -- OK

caller() is the function I am looking for. Is there any function like this?If not, is there a way how to write one?

Thanks

Zoltan

[Tom Lane]

"BARTKO Zoltan" <ba***********@pobox.sk> writes:

caller() is the function I am looking for.

The closest thing you will find is SESSION_USER.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Tom Lane]

"BARTKO Zoltan" <ba***********@pobox.sk> writes:

caller() is the function I am looking for.

The closest thing you will find is SESSION_USER.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Greg Stark]

Tom Lane <tg*@sss.pgh.pa.us> writes:

"BARTKO Zoltan" <ba***********@pobox.sk> writes:

caller() is the function I am looking for.

The closest thing you will find is SESSION_USER.

I think you can have to have a trigger that compared session_user with the
value of the column in OLD and blocked the update/delete if it doesn't match.

--
greg
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Greg Stark]

Tom Lane <tg*@sss.pgh.pa.us> writes:

"BARTKO Zoltan" <ba***********@pobox.sk> writes:

caller() is the function I am looking for.

The closest thing you will find is SESSION_USER.

I think you can have to have a trigger that compared session_user with the
value of the column in OLD and blocked the update/delete if it doesn't match.

--
greg
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly