From: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
---|---|
To: | Jerry LeVan <jerry(dot)levan(at)eku(dot)edu> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Message-ID as unique key? |
Date: | 2004-10-12 15:20:03 |
Message-ID: | 1097594403.21062.246.camel@sabrina.peacock.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2004-10-12 15:25:39 | Re: Message-ID as unique key? |
Previous Message | Dennis Gearon | 2004-10-12 15:13:07 | connection or query affected |