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

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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: many row updates
Next
From: "John D. Burger"
Date:
Subject: Re: pgstattuple output?