Re: Trigger for Truncate event

Поиск
Список
Период
Сортировка
От Jignesh Shah
Тема Re: Trigger for Truncate event
Дата
Msg-id c11950270908271104k3ec8e180w3e6144b25dbd7651@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Trigger for Truncate event  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-novice
Дерево обсуждения
Hmm..you are correct.
 
Thanks.

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

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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Trigger for Truncate event
Следующее
От: Steve T
Дата:
Сообщение: Re: Speeding up 'bulk' delete (and/or seeing what is going on while the delete is being processed)