From: | Richard Smith <richard(at)indigo3(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Per session variables |
Date: | 2006-05-27 19:13:19 |
Message-ID: | 4478A4CF.10107@indigo3.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi guys,
I've googled about a bit, and found some ideas for solving this problem,
but I thought I'd pose the question, in the hope that someone can
suggest something.
I've got a web application that needs to do audit logging, taking some
information provided by the webapp such as user, request path, remote IP
etc...
Since I can't create users in postgres, and would like to be able to do
the audit logging transparently, would anyone have any ideas as to a way
I can do this kind of thing.
I need to avoid using external libraries if possible so if anyone has
any tricks I'd appreciate it.
I did find a mention of some features in 8.0 that I might be able to
exploit, however there was no details of what those features were, your
typical useless reply to a mailing list post. There was also a myfunc
module that would fill my needs, but I don't really want to load
external modules into the db.
I'm running PG8.1
Ta
--
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-27 20:16:58 | Re: [PL/PGSQL] (Bug/Feature problem) with recursive Trigger |
Previous Message | Rafal Pietrak | 2006-05-27 19:06:16 | Re: a row disapearing |