[Solved] Generic logging system for pre-hstore using plperl triggers
От | Diego Augusto Molina |
---|---|
Тема | [Solved] Generic logging system for pre-hstore using plperl triggers |
Дата | |
Msg-id | CAGOxLdEMcrcJPv55JGAzcfPxBbznxCgeLWR-HjO4nmaGY7G7Vw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [Solved] Generic logging system for pre-hstore using
plperl triggers
|
Список | 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@gmail.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
В списке pgsql-general по дате отправления: