Re: Fails to add function from file with \i in psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: szroland(at)freemail(dot)hu, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Fails to add function from file with \i in psql
Date: 2000-11-27 01:06:59
Message-ID: 5482.975287219@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

pgsql-bugs(at)postgresql(dot)org writes:
> psql:triggertest.sql:4: NOTICE: plpgsql: ERROR during compile of c_fnc
> near line 1
> "sql:triggertest.sql:4: ERROR: parse error at or near "

Sounds like you saved your file with DOS-style newlines (\r\n). The
plpgsql parser doesn't think \r is whitespace. That's changed for 7.1,
but in the meantime use a less Microsofty editor...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dino Dini 2000-11-27 05:03:14 case / coalesce problem with strings
Previous Message pgsql-bugs 2000-11-26 20:46:52 Special character pervents psql from parsing?