Thread: Bug in functions returning setof where table has dropped column

Bug in functions returning setof where table has dropped column

From
"C9 Developer"
Date:
OS and Version : Windows 2003 / Cygwin, postgresql 7.4.1



Function returns error message:

ERROR:  query-specified return row and actual function
return row do not match

when running a 'setof' function where a table has a
dropped column.

Not sure if this has been reported previously. A better
description than I could write can be found here:


http://groups.google.co.uk/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=20040110181228.GA17882%40computing-services.oxford.ac.uk&rnum=2&prev=/groups%3Fq%3D%2522query-specified%2Breturn%2Brow%2Band%2Bactual%2Bfunction%2Breturn%2Brow%2Bdo%2Bnot%2Bmatch%2522%252Cpostgres%26ie%3DUTF-8%26oe%3DUTF-8%26hl%3Den%26btnG%3DGoogle%2BSearch

Apart from OS, my experience was exactly as described
in above link, though it was clear if a bug had been
reported.

Rgds

P Biggs

-----------------------------------
See what's new at http://elvis.com!