Re: Connected user in a triggerfunction

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

Op donderdag 26 januari 2006 10:02, schreef Richard Huxton:
> 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