Thread: unique ID

I am starting to build an internet directory. What type of system
generated unique ID would you suggest?

On Fri, Jul 23, 2004 at 06:56:49 -0700,
  sql@aniota.com wrote:
> I am starting to build an internet directory. What type of system
> generated unique ID would you suggest?

I am not sure that it makes sense to generate an ID for this purpose,
rather than using a URL, email address or whatever else makes sense
for your directory as the primary key.
However, if you do want one, you want to use bigserial (the in4 serial
might not be big enough for your purpose).

----- Original Message -----
From: <sql@aniota.com>
To: <pgsql-novice@postgresql.org>
Sent: Friday, July 23, 2004 6:56 AM
Subject: [NOVICE] unique ID


> I am starting to build an internet directory. What type of system
> generated unique ID would you suggest?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

----- Original Message -----
From: "Bruno Wolff III" <bruno@wolff.to>
To: <sql@aniota.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Friday, July 23, 2004 8:54 AM
Subject: Re: [NOVICE] unique ID


> On Fri, Jul 23, 2004 at 06:56:49 -0700,
>   sql@aniota.com wrote:
> > I am starting to build an internet directory. What type of system
> > generated unique ID would you suggest?
>
> I am not sure that it makes sense to generate an ID for this purpose,
> rather than using a URL, email address or whatever else makes sense
> for your directory as the primary key.
> However, if you do want one, you want to use bigserial (the in4 serial
> might not be big enough for your purpose).
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>