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

From Dan Wilson
Subject Re: Trigger/Function problem
Date
Msg-id 013a01c06657$c8ceae30$078353d8@danwilson
Whole thread Raw
In response to Trigger/Function problem  ("Dan Wilson" <phpPgAdmin@acucore.com>)
List pgsql-general
That was it!  Thanks Tom.  I just put this functionality into phpPgAdmin and
of course it is taking the newline char from the browser's OS.

Thanks for all your help!

-Dan



> "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: Jim Mercer
Date:
Subject: adding a C function with optional arguments
Next
From: Tom Lane
Date:
Subject: Re: adding a C function with optional arguments