[Solved] Generic logging system for pre-hstore using plperl triggers

From: Diego Augusto Molina <diegoaugustomolina(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [Solved] Generic logging system for pre-hstore using plperl triggers
Date: 2011-09-26 23:39:09
Message-ID: CAGOxLdEMcrcJPv55JGAzcfPxBbznxCgeLWR-HjO4nmaGY7G7Vw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I had to implement a logging system for some DBs in work. It's
generic and implemented using plperl. I've seen tons of mails on the
list from newbies asking for something like this using plpgsql, but no
specific solution is pointed for them. I think this may discourage
some of them.
The system is implemented using a separate schema with whatever name
you want, and has some really nice features: relevant tables can be
rotated to facilitate auditing, each logged action refers to the
modified tuple by pk, which you don't even have to (but can) specify
when reating the trigger, and some more. Performance is very
acceptable (test cases and suggestions are welcome), and never had a
problem since the about 8 months it's been working.
In the wiki some points are mentioned, but all is _too_ general and
for a vanilla pg-8.4 you won't have the hstore facility (note that
upgrading is not always a choice).
Will it worth pasting the little code in here or that'll be ignored?

--
Diego Augusto Molina
diegoaugustomolina(at)gmail(dot)com

ES: Por favor, evite adjuntar documentos de Microsoft Office. Serán
desestimados.
EN: Please, avoid attaching Microsoft Office documents. They shall be discarded.
LINK: http://www.gnu.org/philosophy/no-word-attachments.html

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Filip Rembiałkowski 2011-09-27 00:19:44 Re: [Solved] Generic logging system for pre-hstore using plperl triggers
Previous Message richter 2011-09-26 22:52:17 RES: Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries?