error after dropping column

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: error after dropping column
Date: 2010-01-11 14:27:15
Message-ID: 92869e661001110627g3692ef9aib9c71343d6b73baa@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi all,

not sure if I should send it here; if it was reported before in
pgsql-general. you can just ignore it :-)

with postgres 8.2.4:

create table test (t1 text);
create function row2text(test) returns text as 'select $1::text' language
sql immutable;
create index test_row2text_idx on test( row2text(test) );
alter table test add t2 text;
alter table test drop t2;
insert into test(t1) select 'foo';

ERROR: table row type and query-specified row type do not match
DETAIL: Physical storage mismatch on dropped attribute at ordinal position
2.

--
Filip Rembiałkowski
JID,mailto:filip(dot)rembialkowski(at)gmail(dot)com
http://filip.rembialkowski.net/

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2010-01-11 14:38:34 Re: BUG #5271: pg_dump: schema with OID 22519 does not exist
Previous Message Michael Felt 2010-01-11 07:57:42 Re: BUG #5267: initdb fails on AIX: could not identify current directory