Jasen Betts <ja...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs