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.rembialkow...@gmail.com http://filip.rembialkowski.net/