Received: from mail-smtp02.one.net.au (mail-pop03.one.net.au [203.101.17.172]) by hub.org (8.10.1/8.10.1) with SMTP id e7MAsXT79650 for ; Tue, 22 Aug 2000 06:54:34 -0400 (EDT) Received: (qmail 16844 invoked from network); 22 Aug 2000 10:54:24 -0000 Received: from async103-syd-isp-235.nas.one.net.au (HELO darthvader.e-magine.com.au) (61.12.13.104) by mail-pop03.one.net.au with SMTP; 22 Aug 2000 10:54:24 -0000 Message-Id: <4.3.2.7.0.20000822205039.00b11e90@mail.e-magine.com.au> X-Sender: e-magine@mail.e-magine.com.au X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Tue, 22 Aug 2000 21:16:23 +1000 To: pgsql-sql@postgresql.org From: Keith Wong Subject: tip: weird parse error for pl/pgsql In-Reply-To: <6585.000822@nlr.ru> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200008/220 Hi everyone, After fiddling for about a day to work out why my pl/pgsql stored procedures weren't working I finally discovered why. It seems that pl/pgsql has a problem parsing Window style new line characters. I was writing my stored procedures using a Windows app, and then running them on my Linux Postgres database. It keeped on giving me... an error found one line 1 near " " which wasn't very helpful. Anyway just make sure you write your stored procs in your Unix environment or save them as Unix format. I hope this tip saves somebody some time. :) Cheers, Keith.