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

On Fri, Jul 23, 2004 at 06:56:49 -0700,
sql (AT) aniota (DOT) com wrote:
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

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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

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


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org