Re: Connected user in a triggerfunction

From: Dick Kniep <dick(at)kniep(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Connected user in a triggerfunction
Date: 2006-01-26 08:39:47
Message-ID: 200601260939.48128.dick@kniep.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-01-26 08:49:01 Re: comparing OLD and NEW in update trigger..
Previous Message Benjamin Smith 2006-01-26 08:14:41 Re: Postgresql Segfault in 8.1