Trigger on a column
| От | Josep Sanmartí |
|---|---|
| Тема | Trigger on a column |
| Дата | |
| Msg-id | 43E71A6C.6070104@openwired.net обсуждение исходный текст |
| Список | pgsql-sql |
Hi, My trigger's running on a table that works perfectly. This trigger calls a function that inserts or modifies a row of a different table. My problem is that I need to optimize this trigger, and the only way that I've found is to fire the trigger when certain table fields are modified. I do it like this: CREATE TRIGGER tr_barra_aps AFTER INSERT OR DELETE OR UPDATE OF status ON am_access_point EXECUTE PROCEDURE f_barra_aps(); but I get this error: ERROR: syntax error at or near "status" at character 62 The status field is correct. Can anybody help me? Thanks -- Josep Sanmarti Analista de Projectes OpenWired Caballero 87 - Bajos 08029 - Barcelona Tel. 93 495 0990 Fax. 93 419 4591 Openwired Alejandro Villegas,29 28043 - MADRID - ESPAÑA Teléfono: 91 300 51 09 Fax: 91 300 28 13 http://www.openwired.com
В списке pgsql-sql по дате отправления: