On Thu, Aug 27, 2009 at 11:20 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:
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