Re: Message-ID as unique key?

From: Jerry LeVan <jerry(dot)levan(at)eku(dot)edu>
To: Doug McNaught <doug(at)mcnaught(dot)org>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Message-ID as unique key?
Date: 2004-10-12 15:34:59
Message-ID: 46ECFBCE-1C64-11D9-854B-000393779D9C@eku.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)levan(at)eku(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-12 15:37:45 Re: Confused with LABEL and LOOP
Previous Message Michael Fuhr 2004-10-12 15:34:00 Re: Return resultset from a function