Re: Trigger for Truncate event
| От | Jignesh Shah |
|---|---|
| Тема | Re: Trigger for Truncate event |
| Дата | |
| Msg-id | c11950270908271037h50fa422ds57dcc20664d2a6e9@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Trigger for Truncate event ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
| Ответы |
Re: Trigger for Truncate event
|
| Список | pgsql-novice |
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
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
Thanks,
Jignesh
On Thu, Aug 27, 2009 at 1:47 PM, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
In response to Jignesh Shah :> Thanks Kretschmer. Could you tell me what "return new" meant for?A trigger function must return either NULL or a record/row value having
exactly the structure of the table the trigger was fired for. Okay, in
this case, you can also return NULL. NEW means the new record, but you
need it only for row level triggers afaik.
Regards, Andreas--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
--
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 по дате отправления: