Re: [GENERAL] using ID as a key

From: <kaiq(at)realtyideas(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>, Marc Tardif <admin(at)wtbwts(dot)com>, sheila bel <sheilabel(at)hotmail(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] using ID as a key
Date: 2000-02-04 22:56:11
Message-ID: Pine.LNX.4.10.10002041655050.28445-100000@picasso.realtyideas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ya, and there is always this listing to ask ;-)

On Fri, 4 Feb 2000, Bruce Momjian wrote:

> > 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
> ************
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ed Loehr 2000-02-04 23:17:45 Re: [GENERAL] using ID as a key
Previous Message Ed Loehr 2000-02-04 22:39:46 Re: [GENERAL] using ID as a key