Re: Trigger for Truncate event

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


--

Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice