Re: Surrogate keys - Mailing list pgsql-hackers

From Mike Rylander
Subject Re: Surrogate keys
Date
Msg-id b918cf3d0601202023l16a12103p203fdc40ad0bf7d8@mail.gmail.com
Whole thread Raw
In response to Re: Surrogate keys  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-hackers
On 1/21/06, Christopher Browne <cbbrowne@acm.org> wrote:
> > On 1/19/06, Pollard, Mike <mpollard@cincom.com> wrote:
> >> Martijn van Oosterhout wrote:
> >>
> >> > Please provides natural keys for any of the following:
> >> >
> >> > - A Person
> >> > - A phone call: (from,to,date,time,duration) is not enough
> >> > - A physical address
> >> > - A phone line: (phone numbers arn't unique over time)
> >> > - An internet account: (usernames not unique over time either)
> >>
> >> Ahh, a challenge.  Hmm, not sure about all of them, but here goes:
> >>
> >> A Person - well, you could use a bit map of their fingerprints, or maybe
> >> their retinal scan.  Of course, that could change due to serious injury.
> >> Maybe some kind of representation of their DNA?
> >
> > Unless the person in question happens to be a chimera (yes, they do exist).
> >
> > ;-)
>
> Yeah, I saw that episode of CSI!  :-)

Heh.  I didn't realize they did that already.  I was thinking of the
show "I Am My Own Twin" from the Discovery Health Channel.

Couldn't find a link from the official page, but:
http://www.globalspin.com/mt/archives/000547.html .

> --
> "cbbrowne","@","gmail.com"
> http://linuxdatabases.info/info/lsf.html
> "Cat's motto: No matter what you've done wrong, always try to make it
> look like the dog did it." -- Unknown
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>


--
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: strange behavior on locks
Next
From: Michael Adler
Date:
Subject: Re: strange behavior on locks