Re: index row size exceeds btree maximum, 2713 - Solutions?

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?
Date: 2005-07-18 20:32:33
Message-ID: c2d9e70e05071813323a499a41@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ;)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guy Rouillier 2005-07-18 20:40:37 Re: How to find the number of rows deleted
Previous Message Jaime Casanova 2005-07-18 20:27:51 Re: index row size exceeds btree maximum, 2713 - Solutions?