Jim Wilson <j...@kelcomaine.com> writes:
> After upgrading from 8.3 I found an unusual error related to a plpgsql
> function.
> The database includes a table named "detail".
> The procedure/function in question includes a declaration of detail%rowtype.
Hmm. The reason that doesn't work is that DETAIL is now a keyword in
plpgsql. It's supposed to be an unreserved keyword, so ideally this
usage would work; but I see that plpgsql's read_datatype() function
is naive about such cases (in particular, it fails to check for the
%rowtype construct). I'll see about fixing it, but in the meantime
your best answer is to quote the name.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
