Thread

1. Globally Unique IDs?

   Rose, Keith <keithr@aiinet.com> — 2001-03-30T18:42:52Z

   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)
   
   
   

2. Re: Globally Unique IDs?

   Mitch Vincent <mitch@venux.net> — 2001-03-30T18:46:45Z

   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
   >
   
   
   

3. Re: Globally Unique IDs?

   Andy Koch <dfunct@telus.net> — 2001-03-30T19:06:15Z

   At 01:42 PM 3/30/2001 -0500, you wrote:
   >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?
   
   
   I'm far from an expert with Postgresql, but I was just thinking the other 
   day that you could probably use a single "sequence" in postgres for a 
   number of tables to make sure id's are unique across multiple tables.
   
   If your not familiar with sequences, see here:
   http://www.postgresql.org/devel-corner/docs/user/datatype.html#DATATYPE-SERIAL