Re: index row requires 10040 bytes, maximum size is 8191
От | Joshua D. Drake |
---|---|
Тема | Re: index row requires 10040 bytes, maximum size is 8191 |
Дата | |
Msg-id | 1289595146.4869.13.camel@jd-desktop обсуждение исходный текст |
Ответ на | index row requires 10040 bytes, maximum size is 8191 (akp geek <akpgeek@gmail.com>) |
Ответы |
Re: index row requires 10040 bytes, maximum size is 8191
Re: index row requires 10040 bytes, maximum size is 8191 |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: