The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=634 ====================================================================== Reported By: maximP Assigned To: paul ====================================================================== Project: DBMail Issue ID: 634 Category: Database layer Reproducibility: sometimes Severity: major Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: 2.2.6 ====================================================================== Date Submitted: 30-Jul-07 07:41 CEST Last Modified: 27-Aug-07 11:48 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. ====================================================================== ---------------------------------------------------------------------- paul - 27-Aug-07 11:48 ---------------------------------------------------------------------- I've implemented partial indexing on the headervalue field and made sure they are used correctly (afaict). Issue History Date Modified Username Field Change ====================================================================== 30-Jul-07 07:41 maximP New Issue 27-Aug-07 11:48 paul Note Added: 0002334 27-Aug-07 11:48 paul Assigned To => paul 27-Aug-07 11:48 paul Status new => resolved 27-Aug-07 11:48 paul Resolution open => fixed 27-Aug-07 11:48 paul Fixed in Version => 2.2.6 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
