Re: BUG #5117: Table type Function Bug when column dropped

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: cf of <ccooffeee(at)hotmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5117: Table type Function Bug when column dropped
Date: 2009-10-15 14:48:36
Message-ID: 20091015144836.GE4788@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

cf of wrote:

> alter table test_table drop column key3;
>
> select * from test_function();
> ERROR: wrong record type supplied in RETURN NEXT
> DETAIL: Number of returned columns (2) does not match expected column
> count (3).

Known problem, fixed in HEAD (8.5-to-be). Not sure how backpatchable
the fix was.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2009-10-15 15:29:27 Re: BUG #5118: start-status-insert-fatal
Previous Message Kevin Grittner 2009-10-15 14:30:35 Re: issue with integer nullable column and value 0