James Robinson <jlrobins(at)socialserve(dot)com> writes:
> 7.4.6 results:
> xs2 /tmp> psql ssc_sav < pets.sql
> BEGIN
> ALTER TABLE
> CREATE FUNCTION
> ERROR: syntax error at or near "ELSEIF" at character 1
> CONTEXT: PL/pgSQL function "fix_pets" line 16 at SQL statement
Um ... I get the "no code determined" message in 7.4.6 too, and indeed
in every version of plpgsql (ok, I didn't try before 7.2). Given the
way plpgsql works, it'd be hard to make it do anything else. It thinks
that ELSEIF (or any other unrecognized keyword) is a SQL command keyword.
regards, tom lane