On Tue, 2004-10-12 at 17:01, Jerry LeVan wrote: > Hi, > I am futzing around with Andrew Stuarts "Catchmail" program > that stores emails into a postgresql database. > > I want to avoid inserting the same email more than once... > (pieces of the email actually get emplaced into several > tables). > > Is the "Message-ID" header field a globally unique identifer?
Its supposed to be that, yes. Unless you meet a broken client or MTA. > I eventually want to have a cron job process my inbox and don't > want successive cron tasks to keep re-entering the same email :) Why not a script which receives the mail in behalf of the user? Time to run some spam checkers too. Regards Tino ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html