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