Connected user in a triggerfunction

am 20.01.2006, um 7:56:38 +0100 mailte Dick Kniep folgendes:

Hi list,

We are using logging in a database based on triggers and plpgsql functions.
This works OK. However, we want deletes to be recorded too, and there we want
the user who connected to be recorded in the log. So, how can I get the
connected user in a triggerfunction?

select current_user;

HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

On Fri, Jan 20, 2006 at 07:56:38AM +0100, Dick Kniep wrote:

We are using logging in a database based on triggers and plpgsql functions.
This works OK. However, we want deletes to be recorded too, and there we want
the user who connected to be recorded in the log. So, how can I get the
connected user in a triggerfunction?

Use SESSION_USER or CURRENT_USER. They're usually the same but see
the documentation for how they can differ:

http://www.postgresql.org/docs/8.1/interactive/functions-info.html

--
Michael Fuhr

Anyone?

Op vrijdag 20 januari 2006 07:56, schreef Dick Kniep:

Dick Kniep wrote:

Anyone?

I thought I saw an answer to this yesterday. Have you tried CURRENT_USER
? It's in the "functions and operators" section of the manuals (contrary
to appearance, it is a function).

Op vrijdag 20 januari 2006 07:56, schreef Dick Kniep:

Hi list,

We are using logging in a database based on triggers and plpgsql functions.
This works OK. However, we want deletes to be recorded too, and there we
want the user who connected to be recorded in the log. So, how can I get
the connected user in a triggerfunction?

Cheers,
Dick Kniep

--
Richard Huxton
Archonet Ltd

Oops, Sorry, didn't get the answers untill just now...

Op donderdag 26 januari 2006 10:02, schreef Richard Huxton: