index row requires 10040 bytes, maximum size is 8191

From: akp geek <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: index row requires 10040 bytes, maximum size is 8191
Date: 2010-11-12 20:47:39
Message-ID: AANLkTikJtc+jQCpE6RUoWnKzbTTWjtEaozi7sZJLN2dO@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Müller 2010-11-12 20:49:57 Re: Seeking advice on database replication.
Previous Message Clark C. Evans 2010-11-12 20:24:36 Re: More then 1600 columns?