Re: IS it a good practice to use SERIAL as Primary Key? - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: IS it a good practice to use SERIAL as Primary Key?
Date
Msg-id 1164656658.16182.72.camel@localhost.localdomain
Whole thread Raw
In response to Re: IS it a good practice to use SERIAL as Primary Key?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
> There are lots of numbers.  Credit card numbers, account numbers
> sales ticket numbers, etc, etc ad nauseum.  Julian day and Julian
> date, even.  You can't have lived in "the west" in the past 30 years
>  without being surrounded by them.
>
> It's their blind use in *every* table which I take issue with, *most
> especially* when they are the only unique key.

There is also *almost* always a way to have a natural and artificial
key.

Joshua D. Drake


>
> - --
> Ron Johnson, Jr.
> Jefferson LA  USA
>
> Is "common sense" really valid?
> For example, it is "common sense" to white-power racists that
> whites are superior to blacks, and that those with brown skins
> are mud people.
> However, that "common sense" is obviously wrong.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.5 (GNU/Linux)
>
> iD8DBQFFaz8HS9HxQb37XmcRAjbWAKCT2yN84OiemgPnCH2uc0JNMsykxACeOrfI
> vNKts9gWRqq7U3hIyEVNKY8=
> =mGfl
> -----END PGP SIGNATURE-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate




pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?
Next
From: Ron Johnson
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?