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

tip: weird parse error for pl/pgsql

From: Keith Wong <keith(at)e-magine(dot)com(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: tip: weird parse error for pl/pgsql
Date: 2000-08-22 11:16:23
Message-ID: 4.3.2.7.0.20000822205039.00b11e90@mail.e-magine.com.au (view raw or flat)
Thread:
Lists: pgsql-sql
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.


In response to

Responses

pgsql-sql by date

Next:From: Mark VolpeDate: 2000-08-22 13:55:12
Subject: Re: Time Help
Previous:From: Brian C. DoyleDate: 2000-08-22 10:47:19
Subject: Time Help

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