Message-ID as unique key?

Поиск
Список
Период
Сортировка
От Jerry LeVan
Тема Message-ID as unique key?
Дата
Msg-id 8C605CEB-1C5F-11D9-854B-000393779D9C@eku.edu
обсуждение исходный текст
Ответы Re: Message-ID as unique key?  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: Message-ID as unique key?  (Tino Wildenhain <tino@wildenhain.de>)
Re: Message-ID as unique key?  (Doug McNaught <doug@mcnaught.org>)
Re: Message-ID as unique key?  (Dawid Kuroczko <qnex42@gmail.com>)
Re: Message-ID as unique key?  (Steve Atkins <steve@blighty.com>)
Re: Message-ID as unique key?  ("Daniel Verite" <daniel@manitou-mail.org>)
Список pgsql-general
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?

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 :)

Jerry


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 'NOW' in UTC with no timezone
Следующее
От: Jeff Boes
Дата:
Сообщение: Re: Rule uses wrong value