Re: Changelog

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=commitdif
f;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
DBmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail