Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux