Bug in functions returning setof where table has dropped column

From: "C9 Developer" <c9groups(at)elvis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug in functions returning setof where table has dropped column
Date: 2004-04-28 16:27:53
Message-ID: 20040428092753.9936.h007.c007.wm@mail.elvis.com.criticalpath.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Browse pgsql-bugs by date

  From Date Subject
Next Message Mike Quinn 2004-04-28 17:16:19 Re: make check regression "test stats" failed
Previous Message Tom Lane 2004-04-28 04:45:00 Re: Problem when truncate table and get the OID from PQftable