Re: Trigger for Truncate event - Mailing list pgsql-novice

Jignesh Shah wrote on 27.08.2009 19:37:
> Thanks Andreas, when I tried to create trigger it gives me error. Could
> you tell me what is wrong?
>
> mydb=# CREATE TRIGGER truncate_trigger
> mydb-# AFTER TRUNCATE ON mytable
> mydb-# FOR EACH STATEMENT EXECUTE PROCEDURE my_test();
> ERROR:  syntax error at or near "TRUNCATE" at character 52
> LINE 2: AFTER TRUNCATE ON mytable

You are probably using a version prior to 8.4

You need 8.4 to create triggers for TRUNCATE

Thomas