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/

Reply via email to