Re: index row requires 10040 bytes, maximum size is 8191

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

>
> Regards
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt