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. :)
In response to
pgsql-sql by date
|Next:||From: Mark Volpe||Date: 2000-08-22 13:55:12|
|Subject: Re: Time Help|
|Previous:||From: Brian C. Doyle||Date: 2000-08-22 10:47:19|
|Subject: Time Help|