Re: Message-ID as unique key?

Поиск
Список
Период
Сортировка
От Jerry LeVan
Тема Re: Message-ID as unique key?
Дата
Msg-id 46ECFBCE-1C64-11D9-854B-000393779D9C@eku.edu
обсуждение исходный текст
Ответ на Re: Message-ID as unique key?  (Doug McNaught <doug@mcnaught.org>)
Список pgsql-general
Well, this is for my personal mail...I think I will
probably give it a try.

The program can log errors so in the few cases that
might occur I think I can "manufacture" my own message
id.

I guess that the bottom line is that if it exists it
is unique...

Jerry

On Oct 12, 2004, at 11:25 AM, Doug McNaught wrote:

> 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Return resultset from a function
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Confused with LABEL and LOOP