From: | "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg> |
---|---|
To: | <Dave(at)micro-automation(dot)net>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: globally unique ID |
Date: | 2002-03-18 15:38:37 |
Message-ID: | 002b01c1ce92$f8dcc6d0$9b0e32d4@sirma.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
----- Original Message -----
From: "Dave Cramer" <Dave(at)micro-automation(dot)net>
> Not knowing oracle at all, could you be more specific?
>
yes, I need a way to generate a globally unique number that will identify
one database from another one
in Oracle, calling sys_guid() will return 16-byte unique number which is
globally unique
this is from the Oracle docs: "On most platforms, the generated identifier
consists of a host identifier and a process or thread identifier of the
process or thread invoking the function, and a nonrepeating value (sequence
of bytes) for that process or thread"
is there an equivalent in Postgres?
thanx,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
From | Date | Subject | |
---|---|---|---|
Next Message | Peter V Cooper | 2002-03-18 15:51:38 | Re: Scrolling through cursors |
Previous Message | Dave Cramer | 2002-03-18 15:28:53 | Re: globally unique ID |