Q: Log, via triggers
| От | Vazsonyi Peter[ke] |
|---|---|
| Тема | Q: Log, via triggers |
| Дата | |
| Msg-id | Pine.A32.4.05.9901041702230.16028-100000@kornel.szif.hu обсуждение исходный текст |
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: