Re: Trigger/Function problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Trigger/Function problem
Date
Msg-id 9806.976852010@sss.pgh.pa.us
Whole thread Raw
In response to Trigger/Function problem  ("Dan Wilson" <phpPgAdmin@acucore.com>)
List pgsql-general
"Dan Wilson" <phpPgAdmin@acucore.com> writes:
> I get the following error:
> NOTICE:  plpgsql: ERROR during compile of f_auto_date near line 1
> "RROR:  parse error at or near "

Just like that, eh?  It looks like the parser is spitting up on a \r
in the function text.  Try saving your script with Unix-style newlines.

For 7.1 the plpgsql parser has been fixed to accept DOS-ish newlines,
but for now you gotta be careful...

            regards, tom lane

pgsql-general by date:

Previous
From: "Dan Wilson"
Date:
Subject: Re: Trigger/Function problem
Next
From: Tom Lane
Date:
Subject: Re: create trigger (can't compile example, problem with include files)