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
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general