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.