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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
