Log, via triggers.

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

Responses

Browse pgsql-admin by date

  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.