Re: [Info-ingres] Re: dbms sequences access

On 2006-07-10, Roy Hann <specially@xxxxxxxxxxxxxxxxxxxxx> wrote:
"Emiliano" <emile@xxxxxxxxxxxxxx> wrote in message
news:336ba$44b20a05$3ec29fe3$23622@xxxxxxxxxxxxxxxxx
The first issue then becomes, what is stored *in addition* to this
auto-increment ID? The ID in and of itself seems useless. But if
there's something of value attached to it, then it can be useful:
"retrieve for me the added-value data to the email message uniquely
identified by XYZ"

But that only begs the question. Why would I be interested in XYZ among all
possible IDs?

You're not. You're interested in the added-value data, whatever that
may be (I can't think of any), and you need a way to accurately
describe to the party on the other side which message you're
interested in. Why would any agency have an intrinsic interest in
your SSN? It's still servicing a need.

So that still leaves the question *why* these email messages need to
be uniquely identified. I have my hypothetical added-value data but
that's not too strong a case since I can't think of any real-life
added-value data that I would be interested in. I'm curious what
reason the OP has for wanting to uniquely identify emails, but if you
take it as a given that there's a need to do so, generating a key for
all messages that pass through the system seems like a good enough
approach for his circumstances.

That still doesn't address the potential problem of the sequence running
dry or wrapping around and introducing duplicates, though.

--
Emiliano
.

Relevant Pages

  • Re: [Info-ingres] Re: dbms sequences access
    ... auto-increment ID? ... The ID in and of itself seems useless. ... "retrieve for me the added-value data to the email message uniquely ... Why would I be interested in XYZ among all ...
    (comp.databases.ingres)
  • Getting an email after an install?
    ... I have an important email message I need to retrieve on ... a W2KPro machine/hd. ... computer and do a new install/not new format, ...
    (microsoft.public.win2000.setup)