Postgres Pro
Downloads
Home   >   mailing lists

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

From Dennis Bjorklund
Subject Re: index row size exceeds btree maximum, 2713 - Solutions?
Date
Msg-id Pine.LNX.4.44.0507191240590.7470-100000@zigo.dhs.org
Whole thread Raw
In response to Re: index row size exceeds btree maximum, 2713 - Solutions?  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: index row size exceeds btree maximum, 2713 -
List pgsql-general
Tree view 
On Mon, 18 Jul 2005, Jaime Casanova wrote:

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

You can index text fields, but you can't insert values bigger then
BLOCKSIZE/3 when you have an index on that column.

--
/Dennis Björklund

pgsql-general by date:

Previous
From: "Ilja Golshtein"
Date:
Subject: Old question - failed to find conversion function from "unknown"
Next
From: Richard Huxton
Date:
Subject: Re: Old question - failed to find conversion function from