Jim Wilson <jimw@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
