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)
... can anybody give another solution for logging?
--
NeKo@(kva.hu|Kornel.szif.hu) the servant of Crash