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

Поиск
Список
Период
Сортировка
От carter ck
Тема IS it a good practice to use SERIAL as Primary Key?
Дата
Msg-id BAY101-F21AFC88C072E44631822AED5E20@phx.gbl
обсуждение исходный текст
Ответы 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>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: 8.2Beta3 - create view testview (a,b,c) values (1,2,3),(4,5,6),...
Следующее
От: "zenith siea"
Дата:
Сообщение: 2 problems of my postgresql