Re: Connected user in a triggerfunction

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