> 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
pgsql-bugs by date
|Next:||From: Dino Dini||Date: 2000-11-27 05:03:14|
|Subject: case / coalesce problem with strings|
|Previous:||From: pgsql-bugs||Date: 2000-11-26 20:46:52|
|Subject: Special character pervents psql from parsing?|