From: | SunWuKung <Ralikwen(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | strange plpgsql error |
Date: | 2009-10-11 21:20:32 |
Message-ID: | 25847709.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2009-10-11 21:29:59 | Re: strange plpgsql error |
Previous Message | Scott Marlowe | 2009-10-11 18:32:26 | Re: Granting rights |