index row size exceeds btree maximum

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: index row size exceeds btree maximum
Date: 2005-09-21 20:02:34
Message-ID: 20050921200234.17552.qmail@web52915.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


This appears related to my previous post:
http://archives.postgresql.org/pgsql-general/2005-09/msg00809.php

I setup a unique index using the title, yield, and
directions fields. Some inserts are causing this
error:

DBD::Pg::st execute failed: ERROR: index row size
2832 exceeds btree maximum, 2713
CONTEXT: SQL statement "insert into stuff (title,
yield, directions) values ( $1 , $2 , $3 )"

What do I do?

Thanks,
CSN


__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-09-21 20:07:40 Re: index row size exceeds btree maximum
Previous Message Joshua D. Drake 2005-09-21 19:54:54 Re: Fetching column names for a table