Re: index row size exceeds btree maximum - Mailing list pgsql-general

On Wed, 2005-09-21 at 15:02, CSN wrote:
> 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?

Don't insert such big values?  :)

Actually, the standard solution is to use an md5 of the three fields:

create unique index threefieldindex on table1
(md5(field1||field2||field3));