| From: | "Dan Wilson" <phpPgAdmin(at)acucore(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Trigger/Function problem |
| Date: | 2000-12-15 05:27:46 |
| Message-ID: | 013a01c06657$c8ceae30$078353d8@danwilson |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maarten Boekhold | 2000-12-15 07:29:11 | RE: Postgres failover implementation |
| Previous Message | Tom Lane | 2000-12-15 04:29:31 | Re: adding a C function with optional arguments |