Re: pg.dropped

Full test case, reproduced in 8.4.2 on two different hosts

create table test (id serial primary key, t1 text, t2 text);
create function myhash(test) returns text as 'select md5($1::text)' language
sql immutable;
create index myhash on test( myhash(test) );
alter table test add t3 text;
alter table test drop t3;
insert into test(t1,t2) select 'foo', 'bar';

PS. I realise that marking of CAST (rowtype as text) as immutable may be not
safe.
But this behaviour is probably a bug anyway.

2010/1/7 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> =?UTF-8?Q?Filip_Rembia=C5=82kowski?= <plk(dot)zuber(at)gmail(dot)com> writes:
> > INSERT INTO thetable ( ... ) VALUES ( ... );
> > ERROR: table row type and query-specified row type do not match
>
> If you want any help with this you need to show a *complete* example
> of how to produce this failure.
>
> regards, tom lane
>

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