Re: Connected user in a triggerfunction - Mailing list pgsql-general

From Richard Huxton
Subject Re: Connected user in a triggerfunction
Date
Msg-id 43D89015.8000802@archonet.com
Whole thread Raw
In response to Re: Connected user in a triggerfunction  (Dick Kniep <dick@kniep.nl>)
Responses Re: Connected user in a triggerfunction
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: 2 instances of postmaster with different data directories
Next
From: Robert Korteweg
Date:
Subject: Re: Missing database entry in pg_database