Re: Message-ID as unique key?

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: Message-ID as unique key?
Дата
Msg-id 1097594403.21062.246.camel@sabrina.peacock.de
обсуждение исходный текст
Ответ на Message-ID as unique key?  (Jerry LeVan <jerry.levan@eku.edu>)
Список 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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: Change query priority
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Message-ID as unique key?