Skip site navigation (1) Skip section navigation (2)

Re: Globally Unique IDs?

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "Rose, Keith" <keithr(at)aiinet(dot)com>, "'PostgreSQL General'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Globally Unique IDs?
Date: 2001-03-30 18:46:45
Message-ID: 00f001c0b949$c60fcf90$0b51000a@epox450 (view raw or flat)
Thread:
Lists: pgsql-general
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(at)aiinet(dot)com>
To: "'PostgreSQL General'" <pgsql-general(at)postgresql(dot)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
>


In response to

pgsql-general by date

Next:From: Kevin WillemsDate: 2001-03-30 18:50:15
Subject: SQL Script
Previous:From: Rose, KeithDate: 2001-03-30 18:42:52
Subject: Globally Unique IDs?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group