Re: IS it a good practice to use SERIAL as Primary Key?

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