Re: [GENERAL] using ID as a key - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] using ID as a key
Date
Msg-id 200002042139.QAA00161@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] using ID as a key  (Ed Loehr <eloehr@austin.rr.com>)
Responses Re: [GENERAL] using ID as a key  (<kaiq@realtyideas.com>)
List pgsql-general
> Marc Tardif wrote:
> >
> > I recommend you read Momjian's online book, very informative and provides
> > all the necessary information about using various kinds of id's:
> > http://www.postgresql.org/docs/aw_pgsql_book/index.html
>
> In glancing at Momjian's stuff on this just now, I noticed the book
> could leave the first-time reader with the impression that both OIDs
> and sequences (ie, SERIAL) are viable choices for use as primary keys
> (unintentionally?).  Sequences and SERIALs are not mentioned until
> after a long example of how to do primary keys with OIDs.

Don't glance.  Read the whole chapter.  It will be clear.  If people get
the wrong impression by reading part of the chapter, well, it's their
fault.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Jens Skakkebaek"
Date:
Subject: Help with postmaster on NT: command not found
Next
From:
Date:
Subject: Re: [GENERAL] using ID as a key