Michael Monnerie wrote: > On Dienstag, 31. Juli 2007 Paul J Stevens wrote: >> They were posted on the list. Also you can pickup the change: >> > http://nfg3.nfgs.net/cgi-bin/gitweb.cgi?p=dbmail.git;a=commitdiff;h=8ae82ff426114dc2fc648273a40f053d0cc6e8bc > > I've tried to create the missing indices, but one is not possible: > # CREATE INDEX dbmail_headervalue_3 ON dbmail_headervalue(headervalue); > FEHLER: Indexzeile benötigt 26104 Bytes, Maximalgröße ist 8191 > > Anybody got an idea what to do now?
Nothing? In mysql you can do a index on the first x characters of a field. I'm sure something similar is possible in pgsql, but I haven't had time to figure it out yet. For now, just comment the line involved. btw, FTI is not an option for the headervalue field. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
