On Nov 22, 2006, at 6:23 PM, carter ck wrote:
> 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?
Where did you get that idea? A serial should be good up to at least
2,000,000,000 or so, and if that's not enough there's always bigserial.
>
> 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.
If you want a synthetic primary key then a serial field is the
easiest way to create one.
Cheers,
Steve