Re: index row size exceeds btree maximum, 2713 - Solutions? - Mailing list pgsql-general

From Jaime Casanova
Subject Re: index row size exceeds btree maximum, 2713 - Solutions?
Date
Msg-id c2d9e70e05071813323a499a41@mail.gmail.com
Whole thread Raw
In response to Re: index row size exceeds btree maximum, 2713 - Solutions?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
Responses Re: index row size exceeds btree maximum, 2713 - Solutions?
Re: index row size exceeds btree maximum, 2713 - Solutions?
List pgsql-general
> The index that is failing is CREATE INDEX i1 ON conceptproperty USING btree
> (codingschemename, property, propertyvalue).
>

I don't think you could create indexes on text fields... there are
other type of indexes for that... tsearch2 for example

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-general by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?
Next
From: Tom Lane
Date:
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?