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

From Jasen Betts
Subject whole-row functional index?
Date
Msg-id hka6cs$52q$1@reversiblemaps.ath.cx
Whole thread Raw
Responses Re: whole-row functional index?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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.
jasen=# select version();
-[ RECORD 1 ]-----------------------------------------------------------------------------------------
version | PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2

the function get_text_search_internal returns type tsvector

pgsql-bugs by date:

Previous
From: Isaac Morland
Date:
Subject: Warnings building 8.5alpha3 on Solaris 10
Next
From: Tom Lane
Date:
Subject: Re: Warnings building 8.5alpha3 on Solaris 10