Bug in functions returning setof where table has dropped column - Mailing list pgsql-bugs

From C9 Developer
Subject Bug in functions returning setof where table has dropped column
Date
Msg-id 20040428092753.9936.h007.c007.wm@mail.elvis.com.criticalpath.net
Whole thread Raw
List pgsql-bugs
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!

pgsql-bugs by date:

Previous
From: Jérôme Bouat
Date:
Subject: heterogeneous programs names
Next
From: Aaron Hillegass
Date:
Subject: Large object API problems