Jasen Betts <jasen(at)xnet(dot)co(dot)nz> writes:
> jasen=# update member set id=id where id=441;
> UPDATE 1
> jasen=# create index member_search on member using gin (
> (get_search_text_internal(member)) );
> CREATE INDEX
> jasen=# update member set id=id where id=441;
> ERROR: table row type and query-specified row type do not match
> DETAIL: Physical storage mismatch on dropped attribute at ordinal
> position 109.
http://archives.postgresql.org/pgsql-bugs/2010-01/msg00089.php
This is fixed for the next 8.4 update, but it's not going to be fixed in
8.3.x. Suggest recreating the table without any dropped columns.
regards, tom lane