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

From Doug McNaught
Subject Re: Message-ID as unique key?
Date
Msg-id 87wtxwargs.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Message-ID as unique key?  (Jerry LeVan <jerry.levan@eku.edu>)
Responses Re: Message-ID as unique key?  (Jerry LeVan <jerry.levan@eku.edu>)
List 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 by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: Message-ID as unique key?
Next
From: Dawid Kuroczko
Date:
Subject: Re: Message-ID as unique key?