Ah, you are correct.
Okay, I think I'm close...when I run my function (or any function), I get
the following runtime error:
ERROR: typeidTypeRelid: Invalid type - oid = 0
The exact text of the fn is:
CREATE FUNCTION sp_person_resource() RETURNS OPAQUE AS '
BEGIN INSERT INTO resource(resourceid, name, type, description) values
(1906, ''chris'', ''person'', ''com.commnav....'');
RETURN NEW;
END;'
LANGUAGE 'plpgsql';
What does that error mean? Note that I was getting the same error when I
was running a SELECT fn as well.
thanks
chris
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, October 03, 2000 11:38 AM
To: cmarkiew@commnav.com
Cc: 'Nelson Ferreira Jr'; 'Postgres (E-mail)'
Subject: Re: [GENERAL] trouble with trigger/function???
"chris markiewicz" <cmarkiew@commnav.com> writes:
> NOTICE: plpgsql: ERROR during compile of onefn near line 1
> "RROR: parse error at or near "
The message looks just like that, eh? It's probably complaining about a
carriage return character in the text. Don't prepare your scripts with
DOS-style newline sequences in them. (For 7.1, plpgsql has been fixed
to accept \r as whitespace, but current versions don't...)
regards, tom lane
