Postgres Pro
Downloads
Home   >   mailing lists

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

From carter ck
Subject IS it a good practice to use SERIAL as Primary Key?
Date
Msg-id BAY101-F21AFC88C072E44631822AED5E20@phx.gbl
Whole thread Raw
Responses Re: IS it a good practice to use SERIAL as Primary Key?  (Steve Atkins <steve@blighty.com>)
Re: IS it a good practice to use SERIAL as Primary Key?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: IS it a good practice to use SERIAL as Primary Key?  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: IS it a good practice to use SERIAL as Primary Key?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view 
Hi all,

I am wonderring if it is a good practice to use SERIAL index as primary key,
as it is only available up to 9999999?

Currently i am dealing with storing LDAP users into Postgres and i am
looking for a better way to make use of the DN as primary key instead of
SERIAL index.

Any advice or suggestion is appreciated.

Thanks.

Regards,
Carter

_________________________________________________________________
Find singles online in your area with MSN Dating and Match.com!
http://match.sg.msn.com/match/mt.cfm?pg=channel&tcid=281203

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: 8.2Beta3 - create view testview (a,b,c) values (1,2,3),(4,5,6),...
Next
From: "zenith siea"
Date:
Subject: 2 problems of my postgresql