Postgres Pro
Downloads
Home   >   mailing lists

Re: Fails to add function from file with \i in psql - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Fails to add function from file with \i in psql
Date
Msg-id 5482.975287219@sss.pgh.pa.us
Whole thread Raw
In response to Fails to add function from file with \i in psql  (pgsql-bugs@postgresql.org)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Special character pervents psql from parsing?
Next
From: Dmitry Gercog
Date:
Subject: call plpgsql function bug! (set arguments to NULL)