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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: szroland@freemail.hu, pgsql-bugs@postgresql.org
Date: 2000-11-27T01:06:59Z
Lists: pgsql-bugs
pgsql-bugs@postgresql.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