Re: Message-ID as unique key? - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Message-ID as unique key?
Date
Msg-id 1097594403.21062.246.camel@sabrina.peacock.de
Whole thread Raw
In response to Message-ID as unique key?  (Jerry LeVan <jerry.levan@eku.edu>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Change query priority
Next
From: Doug McNaught
Date:
Subject: Re: Message-ID as unique key?