Right, I replace the table alias irq to instreq and the function works. I don't know what could have been the problem: is irq a reserved word, or it's because the table alias has the same name then the function name. Thanks for pointing me to the right direction. SWK SunWuKung wrote: > > > Yes, I use it as a table alias inside the function. > > Select .......... > irq.instreq_min_metcount, > irq.ref_deptype, > irq.instreq_aggrfunc > From .................. instrument_requirement irq ON ........ > > > > > Adrian Klaver wrote: >> >> On Sunday 11 October 2009 2:20:32 pm SunWuKung wrote: >>> Hi, >>> I have a plpgsql function called irq(IN ulist integer[], .....) >>> It works fine on 8.1 Linux >>> >>> On 8.4 on windows XP running the function gives an error message >>> (Undefined >>> column: 7 ERROR: record "rec" has no field "instreq_id") wich is strange >>> because the underlying query does return that column. >>> I run the create script of irq to create irq2 - and irq2 works fine. >>> I delete irq and rename irq2 to irq and I get the error back. >>> >>> The error is consistent in the sense that if I delete the database and >>> restore it it appears again the same way. >>> >>> Is this a bug? >>> Any suggestion what I should be doing with this? >>> >>> Thanks for the help. >>> SWK >>> -- >>> View this message in context: >>> http://www.nabble.com/strange-plpgsql-error-tp25847709p25847709.html >>> Sent >>> from the PostgreSQL - general mailing list archive at Nabble.com. >> >> Are you using the string 'irq' inside the function? >> >> -- >> Adrian Klaver >> aklaver@xxxxxxxxxxx >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> >> > > -- View this message in context: http://www.nabble.com/strange-plpgsql-error-tp25847709p25847955.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
