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));