From: Josep Sanmartí <josep.sanmarti@openwired.net>
To: pgsql-sql@postgresql.org
Subject: Trigger on a column
Date: Mon, 06 Feb 2006 10:44:12 +0100
Message-ID: <43E71A6C.6070104@openwired.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josep.sanmarti@openwired.net
Subject: Re: Trigger on a column
In-Reply-To: <43E71A6C.6070104@openwired.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox