readthefuckingmanual.net

[SOLVED] ERROR: record "old" is not assigned yet

Error added: 2007-02-05T10:21:45Z

1 people waiting for the answer...

2 answers found.

IF TG_OP = \'DELETE\' THEN
   Do stuff here with OLD.foo
END IF;

IF TG_OP = \'INSERT\' THEN
   Do stuff here with NEW.foo
END IF;

Make sure in your trigger, you have \'FOR EACH ROW\'.  I didn\'t have this piece, and even though I had something similar to above, it kept complaining about the OLD record.

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.

If you want to be notified via email when this is solved, enter your email address here: