RE: Globally Unique IDs?

Well, that is what we are doing. I really haven't looked into Oracle's
implementation.  I actually _just_ got Oracle installed (along-side our
postgres installation) to start playing with it.

-----Original Message-----
From: Mitch Vincent [mailto:mitch@venux.net]
Sent: Friday, March 30, 2001 1:47 PM
To: Rose, Keith; 'PostgreSQL General'
Subject: Re: Globally Unique IDs?


You can get the same result I suppose if you just use the same sequence
across all your tables.. Is Oracle doing anything more than that? You could
even make a quick function to get the next value from a sequence and call it
SYS_GUID() -- just an idea :-)

Good luck!

-Mitch
Software development :
You can have it cheap, fast or working. Choose two.

----- Original Message -----
From: "Rose, Keith" <keithr@aiinet.com>
To: "'PostgreSQL General'" <pgsql-general@postgresql.org>
Sent: Friday, March 30, 2001 1:42 PM
Subject: Globally Unique IDs?


> I am new to the mailing list, but not new to postgres.  I did search
through
> the mail-list archives, and didn't find an answer to this question.
Oracle
> has a concept of a "globally unique ID" which can be gotten from their
> function call SYS_GUID().  Is there any plan to implement this (or
something
> analogous) in a future version of Postgres?
>
> --
> Keith Rose (ext. 2144)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>