Re: whole-row functional index? - Mailing list pgsql-bugs

Jasen Betts <jasen@xnet.co.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