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

From Dick Kniep
Subject Re: Connected user in a triggerfunction
Date
Msg-id 200601260939.48128.dick@kniep.nl
Whole thread Raw
In response to Connected user in a triggerfunction  (Dick Kniep <dick@kniep.nl>)
Responses Re: Connected user in a triggerfunction  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Anyone?

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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq

pgsql-general by date:

Previous
From: Benjamin Smith
Date:
Subject: Re: Postgresql Segfault in 8.1
Next
From: Richard Huxton
Date:
Subject: Re: comparing OLD and NEW in update trigger..