Pl/pgSQL trigger failing and i ant see why

HI all

I have read the skimpy docs on postgres triggers and whilst I can
get a simple trigger working when I try to call a Pl/pgsql function
to return the value I want to set one of the foields in NEW to it wont
work.

immediateparentid_ is INT4

This fails NEW.immediateparentid_ := FindRealParent(NEW.messageid_) ;
This works NEW.immediateparentid_ := 123456 ;

Here are the function's btw I have tested the interactivlky so they
are returning coorect values.

Any one got any ideas? BTW WTF does postgres hide its logs?

Best Regards

Maurice

CREATE FUNCTION FindRealParent(INTEGER) returns INTEGER as '
DECLARE
realid INTEGER;
BEGIN
realid := findbyref($1);
IF realid = 0 THEN
realid := findbysubject($1);
END IF;
RETURN realid;
END;
' LANGUAGE 'plpgsql';

CREATE TRIGGER SetMsgParent BEFORE INSERT on messages_
FOR EACH ROW EXECUTE PROCEDURE SetMsgParent();

CREATE FUNCTION SetMsgParent () returns OPAQUE as '
BEGIN
NEW.immediateparentid_ := FindRealParent(NEW.messageid_) ;
RETURN NEW;
END;
' LANGUAGE 'plpgsql';

CREATE FUNCTION FindRealParent(INTEGER) returns INTEGER as '
DECLARE
realid INTEGER;
BEGIN
realid := findbyref($1);
IF realid = 0 THEN
realid := findbysubject($1);
END IF;
RETURN realid;
END;
' LANGUAGE 'plpgsql';