On 11/12/2010 12:52 PM, Joshua D. Drake wrote:
On Fri, 2010-11-12 at 15:47 -0500, akp geek wrote:
Hi all -
I am trying to create an index on character varying field.
The
column is just character varying with no limit. I am getting the
following
error " index row requires 10040 bytes, maximum size is 8191"
What can I do the postgres.conf to handle this error? Appreciate your
help
You can't. You could create a index on "part" of the data or use full
text.
JD
In some cases, depending on needs, indexing on the md5 hash of such data
can be useful.
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
