> 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