The following issue has been SUBMITTED. ====================================================================== http://dbmail.org/mantis/view.php?id=634 ====================================================================== Reported By: maximP Assigned To: ====================================================================== Project: DBMail Issue ID: 634 Category: Database layer Reproducibility: sometimes Severity: major Priority: normal Status: new target: ====================================================================== Date Submitted: 30-Jul-07 07:41 CEST Last Modified: 30-Jul-07 07:41 CEST ====================================================================== Summary: Can't create PostgreSQL index on headervalue Description: Recent SVN change added new DB indexes creation, but one of them {CREATE INDEX dbmail_headervalue_3 ON dbmail_headervalue(headervalue);} is on unlimited text field. I've got the error message trying to create it:
ERROR: index row size 4056 exceeds btree maximum, 2713 SQL state: 54000 Hint: Values larger than 1/3 of a buffer page cannot be indexed. Consider a function index of an MD5 hash of the value, or use full text indexing. ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 30-Jul-07 07:41 maximP New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
