Message-ID as unique key? - Mailing list pgsql-general

From Jerry LeVan
Subject Message-ID as unique key?
Date
Msg-id 8C605CEB-1C5F-11D9-854B-000393779D9C@eku.edu
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: 'NOW' in UTC with no timezone
Next
From: Jeff Boes
Date:
Subject: Re: Rule uses wrong value