Postgres Pro
Downloads
Home   >   mailing lists

index row requires 10040 bytes, maximum size is 8191 - Mailing list pgsql-general

From akp geek
Subject index row requires 10040 bytes, maximum size is 8191
Date
Msg-id AANLkTikJtc+jQCpE6RUoWnKzbTTWjtEaozi7sZJLN2dO@mail.gmail.com
Whole thread Raw
Responses Re: index row requires 10040 bytes, maximum size is 8191  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Clark C. Evans"
Date:
Subject: Re: More then 1600 columns?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: index row requires 10040 bytes, maximum size is 8191