From: san@cobalt.rmnet.it
To: pgsql-hackers@postgresql.org
To: pgsql-sql@postgresql.org
To: pgsql-novice@postgresql.org
Subject: PL/pgSQL triggers ON INSERT OR UPDATE
Date: Mon, 22 Oct 2001 23:25:44 +0200
Message-ID: <200110222125.XAA30632@cobalt.rmnet.it> (raw)
Hello, I'm trying to set up a trigger on insert or update
but when using the predefined variable ``OLD'' I get a
NOTICE from the trigger function about OLD not being defined yet.
Of course OLD is not defined when the function is triggered on INSERT
event, and I did not mention it if not inside a conditional block
checking for the TG_OP variable being 'UPDATE'.
For better understanding here is some code:
BEGIN
IF TG_OP = 'UPDATE' THEN
IF OLD.id <> NEW.id THEN
-- do the work
END IF
END IF;
END;
Even when TG_OP != 'UPDATE' (INSERT event) I still get an error
message from the pl/pgsql compiler (the first time the trigger is fired).
What should I do then ? Is it still possible to use the same function
for UPDATE OR INSERT events ?
TIA
--san;
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: san@cobalt.rmnet.it, pgsql-hackers@postgresql.org, pgsql-novice@postgresql.org
Subject: Re: PL/pgSQL triggers ON INSERT OR UPDATE
In-Reply-To: <200110222125.XAA30632@cobalt.rmnet.it>
* 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