Re: Trigger for Truncate event

Hmm..you are correct.

Thanks.

On Thu, Aug 27, 2009 at 11:20 PM, Thomas Kellerer <spam_eater(at)gmx(dot)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
>>
>
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>