On Tue, 12 Jan 2016, Krzysztof Jakowczyk wrote:
Hello,
Is it possible to log query with parameters executed on subscriber node?
I've tried to add __audit trigger before insert or update, but when
denyaccess trigger is enabled, nothing is logged. Below is my try for
table emp:
CREATE TRIGGER __audit
BEFORE INSERT OR UPDATE OR DELETE ON emp
FOR EACH ROW EXECUTE PROCEDURE save_query();
Setting the trigger to fire always should work.
ALTER TABLE foo ENABLE ALWAYS TRIGGER __audit;
http://www.postgresql.org/docs/9.1/interactive/sql-altertable.html
--
Pozdrawiam,
Krzysztof Jakowczyk
Administrator Systemów Unix
Grupa Unity | ul. Przedmiejska 6-10, 54-201 Wrocław
ul. Conrada 55B, 31-357 Kraków | ul. Złota 59, 00-120 Warszawa
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
