pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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;



view thread (3+ messages)  latest in thread

Message-ID: <200110222125.XAA30632@cobalt.rmnet.it>
Permalink:  ../200110222125.XAA30632@cobalt.rmnet.it/
Also on:    postgresql.org/message-id/200110222125.XAA30632@cobalt.rmnet.it

 · 

reply

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