Re: strange plpgsql error

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(at)comcast(dot)net
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> 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-tp25847709p25847881.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.