On Dienstag, 31. Juli 2007 Paul J Stevens wrote: > > # 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.
Other way round: What if I had that index, and got an entry that big? Crash? Doesn't insert, DB error? Sounds like something should be done there. Yes, it's possible to define an index on substring, I believe. I just wanted to outline this, as it can be a problem when you have that index and try to insert a big field later. > btw, FTI is not an option for the headervalue field. FTI? Whats that? mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
