From: | Vazsonyi Peter <neko(at)krondor(dot)kva(dot)hu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Log, via triggers. |
Date: | 1999-01-02 20:49:57 |
Message-ID: | Pine.LNX.4.02.9901022148210.27417-100000@krondor.kva.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gregg Berkholtz | 1999-01-03 21:58:09 | Help with PostgreSQL startup |
Previous Message | neko | 1999-01-02 19:29:51 | Log, via triggers. |