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)); ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
