Jim Wilson <jimw@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