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