Re: [GENERAL] Odd Invalid type name error in postgresql 9.1

2012-09-26 Thread Tom Lane
Jim Wilson 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 keyw

Re: [GENERAL] Odd Invalid type name error in postgresql 9.1

2012-09-26 Thread Adrian Klaver
On 09/26/2012 12:55 PM, Jim Wilson wrote: Hi, 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. Loading the server from a dump-all at the t

[GENERAL] Odd Invalid type name error in postgresql 9.1

2012-09-26 Thread Jim Wilson
Hi, 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. Loading the server from a dump-all at the time of the upgrade went fine and the functio