| 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: | Whole Thread | Raw Message | 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 |