> I am wonderring if it is a good practice to use SERIAL index as primary key, > as it is only available up to 9999999?
That isn't true. It is much larger that that. If yor need more than that there is always bigserial. serial = int4 bigserial = int8 "" The type names serial and serial4 are equivalent: both create integer columns. The type names bigserial and serial8 work just the same way, except that they create a bigint column. bigserial should be used if you anticipate the use of more than 231 identifiers over the lifetime of the table. "" http://www.postgresql.org/docs/8.2/interactive/datatype-numeric.html#DATATYPE-SERIAL > 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. Here is a similar discussion that you may be enterested in: http://archives.postgresql.org/pgsql-general/2006-10/msg00024.php Regards, Richard Broersma Jr. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
