Armin Größlinger wrote: > Hello, > > I made an upgrade from 2.0.10 to 2.1.7 some days ago and I discoverd two > things I wanted to share with you. My server (Celeron 2.4GHz, 512 MB > RAM) ran PostgreSQL 7.4.7 and there were about 110,000 Mails in the database. > > 1. duplicate References headers in mails: > > After the schema upgrade (which worked without problems) I ran > dbmail-util -ay > to generate the header caches etc. dbmail-util started giving errors like > > Error dbpgsql.c, db_query: Error executing query [INSERT INTO > dbmail_referencesfield (physmessage_id, referencesfield) VALUES > (4933,'[EMAIL PROTECTED]')] : > [ERROR: duplicate key violates unique constraint > "dbmail_referencesfield_1" > ] > > Obviously, some mails have duplicate entries in the References header. I > aborted dbmail-util and changed to the dbmail_referencesfield_1 index (which > is created as "UNIQUE INDEX") _not_ to be UNIQUE which made the problem go > away.
I miss the point. Why would a message need to refer to the same messageid more than once? Could you send me the references headers of such a message? -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
