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 ===
