Postgres Pro
Downloads
Home   >   mailing lists

Connected user in a triggerfunction - Mailing list pgsql-general

From Dick Kniep
Subject Connected user in a triggerfunction
Date
Msg-id 200601200756.38804.dick@kniep.nl
Whole thread Raw
Responses Re: Connected user in a triggerfunction  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Connected user in a triggerfunction  (Michael Fuhr <mike@fuhr.org>)
Re: Connected user in a triggerfunction  (Dick Kniep <dick@kniep.nl>)
List pgsql-general
Tree view 
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: Tom Lane
Date:
Subject: Re: mount -o async - is it safe?
Next
From: "A. Kretschmer"
Date:
Subject: Re: Connected user in a triggerfunction