Log, via triggers.
От | Vazsonyi Peter |
---|---|
Тема | Log, via triggers. |
Дата | |
Msg-id | Pine.LNX.4.02.9901022148210.27417-100000@krondor.kva.hu обсуждение исходный текст |
Ответы |
Re: [ADMIN] Log, via triggers.
Re: [ADMIN] Log, via triggers. |
Список | 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
В списке pgsql-admin по дате отправления: