Search Postgresql Archives

Re: Connected user in a triggerfunction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

--
  Richard Huxton
  Archonet Ltd


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux