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