Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group