Quick Links

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

From:	"carter ck" <carterck32(at)hotmail(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	IS it a good practice to use SERIAL as Primary Key?
Date:	2006-11-23 02:23:51
Message-ID:	BAY101-F21AFC88C072E44631822AED5E20@phx.gbl
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: IS it a good practice to use SERIAL as Primary Key? at 2006-11-23 02:28:52 from Steve Atkins
Re: IS it a good practice to use SERIAL as Primary Key? at 2006-11-23 02:33:10 from Tom Lane
Re: IS it a good practice to use SERIAL as Primary Key? at 2006-11-23 02:36:58 from Richard Broersma Jr
Re: IS it a good practice to use SERIAL as Primary Key? at 2006-11-23 16:23:55 from Ron Johnson

Browse pgsql-general by date

	From	Date	Subject
Next Message	zenith siea	2006-11-23 02:24:08	2 problems of my postgresql
Previous Message	Richard Broersma Jr	2006-11-23 02:03:05	8.2Beta3 - create view testview (a,b,c) values (1,2,3),(4,5,6),...