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

From Ron Johnson
Subject Re: IS it a good practice to use SERIAL as Primary Key?
Date
Msg-id 456B7F4A.8020003@cox.net
Whole thread Raw
In response to Re: IS it a good practice to use SERIAL as Primary Key?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: IS it a good practice to use SERIAL as Primary Key?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 11/27/06 17:25, Joshua D. Drake wrote:
> On Mon, 2006-11-27 at 17:09 -0600, John McCawley wrote:
[snip]
> users
> =====
> id serial unique,
> first_name text,
> last_name text,
> primary key (first_name,last_name)
>
> Yes there are problems with the above, namely you will likely have more
> than one joshua drake.

Right, and then the question gets to: how do you create a "good"
user id?  Many prefer serial types; I prefer something that is not a
monotonically incrementing scalar.

- --
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)

iD8DBQFFa39KS9HxQb37XmcRAm+ZAKCAcpky09a2eTYMZX6HZiPIMECfcgCgrkXf
9oj3C45XcamX8avi5lYVn98=
=f0Ct
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?
Next
From: Scott Ribe
Date:
Subject: Re: IS it a good practice to use SERIAL as Primary Key?