Re: Message-ID as unique key?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Message-ID as unique key?
Дата
Msg-id 87wtxwargs.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Message-ID as unique key?  (Jerry LeVan <jerry.levan@eku.edu>)
Ответы Re: Message-ID as unique key?
Список pgsql-general
Jerry LeVan <jerry.levan@eku.edu> writes:

> 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?

It is intended to be, but since it is generated by either the MUA or
the first MTA that sees the message, there is a lot of scope for
broken software to screw things up.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

В списке pgsql-general по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: Message-ID as unique key?
Следующее
От: Dawid Kuroczko
Дата:
Сообщение: Re: Message-ID as unique key?