Re: Trigger/Function problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Wilson" <phpPgAdmin(at)acucore(dot)com>
Cc: "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trigger/Function problem
Date: 2000-12-15 03:46:50
Message-ID: 9806.976852010@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dan Wilson" <phpPgAdmin(at)acucore(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-15 03:51:38 Re: create trigger (can't compile example, problem with include files)
Previous Message Dan Wilson 2000-12-15 03:10:44 Re: Trigger/Function problem