Re: BUG #5117: Table type Function Bug when column dropped - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #5117: Table type Function Bug when column dropped
Date
Msg-id 20091015144836.GE4788@alvh.no-ip.org
Whole thread Raw
In response to BUG #5117: Table type Function Bug when column dropped  ("cf of" <ccooffeee@hotmail.com>)
List 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

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: issue with integer nullable column and value 0
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5118: start-status-insert-fatal