error after dropping column - Mailing list pgsql-bugs

From Filip Rembiałkowski
Subject error after dropping column
Date
Msg-id 92869e661001110627g3692ef9aib9c71343d6b73baa@mail.gmail.com
Whole thread Raw
Responses Re: error after dropping column  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-bugs
Hi all,<br /><br />not sure if I should send it here; if it was reported before in pgsql-general. you can just ignore
it:-)<br /><br />with postgres 8.2.4:<br /><br />create table test (t1 text);<br />create function row2text(test)
returnstext as 'select $1::text' language sql immutable;<br /> create index test_row2text_idx on test( row2text(test)
);<br/> alter table test add t2 text;<br />alter table test drop t2;<br />insert into test(t1) select 'foo';<br /><br
/>ERROR: table row type and query-specified row type do not match<br />DETAIL:  Physical storage mismatch on dropped
attributeat ordinal position 2.<br /><br /><br clear="all" /><br />-- <br />Filip Rembiałkowski<br />JID,mailto:<a
href="mailto:filip.rembialkowski@gmail.com"target="_blank">filip.rembialkowski@gmail.com</a><br /><a
href="http://filip.rembialkowski.net/"target="_blank">http://filip.rembialkowski.net/</a><br /> 

pgsql-bugs by date:

Previous
From: Michael Felt
Date:
Subject: Re: BUG #5267: initdb fails on AIX: could not identify current directory
Next
From: Robert Haas
Date:
Subject: Re: BUG #5271: pg_dump: schema with OID 22519 does not exist