Connected user in a triggerfunction

From: Dick Kniep <dick(at)kniep(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Connected user in a triggerfunction
Date: 2006-01-20 06:56:38
Message-ID: 200601200756.38804.dick@kniep.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2006-01-20 07:07:05 Re: Connected user in a triggerfunction
Previous Message Tom Lane 2006-01-20 06:00:44 Re: mount -o async - is it safe?