Re: pesky plpgsql

Thanks for your help. I'm going to use this bit of functionality once
or twice, so I went ahead and worked around it in an inelegant, but
effective manner.

Oh well.

Walter

On Tuesday, April 1, 2003, at 10:03 PM, Tom Lane wrote:

> Walter McGinnis <pg(at)mars-hq(dot)com> writes:
>> When I call the function I get the following error:
>> devpps=# select update_cat_keys();
>> NOTICE: plpgsql: ERROR during compile of update_cat_keys near line 2
>> ERROR: parse error at or near ";"
>> The select in the loop runs fine in psql. So I'm stumped...
>
> Hmm, it looks fine to me too. What PG version is this? Could you
> provide the context (table creation commands, etc) so someone else
> could try to run the function?
>
> regards, tom lane
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly