Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group