whole-row functional index?

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: whole-row functional index?
Date: 2010-02-02 21:45:00
Message-ID: hka6cs$52q$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-02-02 22:12:40 Re: Warnings building 8.5alpha3 on Solaris 10
Previous Message Robert Haas 2010-02-02 20:15:58 Re: REFERENCES misbehaves with inheritance