Thread

Q: Log, via triggers

Vazsonyi Peter[ke] <neko@kornel.szif.hu> — 1999-01-04T16:06:15Z

Hello

I tried create a small logging utility for postgresql (6.4, i use it on
redhat-linux-5.2)
I meand with triggers 'n SPI all database change can be hooked.
But this have small problem: in an aborted transaction the triggers run on
changes, but NOT run with the undos.
4xmpl.: 
 --
my=> Begin;
my=> insert into test values ( 'now',0,'Text' );
NOTICE: trigf(): Ok, Insert event sent to log server.
INSERT [5234]
my=> -- Succesfully logged. BUT:
my-> rollback;
ROLLBACK
my=> -- Not logged ;(
 --
Can postgres call trigger beetween rollbacks too? (Nawp: all changes must be
succesfully undoned, this can not depending on triggers)

Ok, that is not works, but realy want to logging to go outside the database.

... can anybody give a solution to this?

--
 NeKo@(kva.hu|Kornel.szif.hu) the servant of Crash