From: Florian Weimer <fweimer@bfk.de>
To: pgsql-sql@postgresql.org
Subject: Transaction-specific global variable
Date: Thu, 03 Feb 2011 09:10:19 +0000
Message-ID: <82zkqdscuc.fsf@mid.bfk.de> (raw)
hstore greatly simplifies creating triggers for logging table changes,
which is great. However, when creating a log record, I would like to
include information about the party who made this change. We
generally do not allow direct database access for application code, so
the PostgreSQL user does not provide sufficient information on its
own. Instead, I'd like to create a transaction-specific variable
which stores context information to be included in the log table. I
suppose I could create a stored procedures in C which provides this
functionality, but I wonder if there is already something similar I
could reuse. For instance, I could reuse the application_name
configuration variable, but this seems a bit gross.
(If you could recommend logging functionality I could learn from, that
would be welcome, too.)
--
Florian Weimer <fweimer@bfk.de>
BFK edv-consulting GmbH http://www.bfk.de/
Kriegsstraße 100 tel: +49-721-96201-1
D-76133 Karlsruhe fax: +49-721-96201-99
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fweimer@bfk.de
Subject: Re: Transaction-specific global variable
In-Reply-To: <82zkqdscuc.fsf@mid.bfk.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox