RE: trouble with trigger/function???

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