| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | "mascarm(at)mascari(dot)com" <mascarm(at)mascari(dot)com> |
| Cc: | "'Soma Interesting'" <dfunct(at)telus(dot)net>, "Rose, Keith" <keithr(at)aiinet(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Globally Unique IDs? |
| Date: | 2001-03-30 19:39:50 |
| Message-ID: | m3itkrnj09.fsf@belphigor.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mike Mascari <mascarm(at)mascari(dot)com> writes:
> I believe Oracle's SYS_GUID will return an ID unique *throughout the world*
> on *all hosts*. Other software uses GUID's for thinks like COM identifiers.
> Typical output looks like:
>
> 351e1cc0-2540-11d5-a5cd-00036d15ee51
>
> and is generated through some heuristics involving the current date, time,
> MAC address, etc. I don't know the specifics -- except that the ID
> generated will not be generated by anyone else anywhere. This would be a
> useful addition, IMHO.
I can see this being useful but I'm not sure it should go into the
core system--it could be an external function in the contrib/
section. We've gotten along without it so far...
Oracle is a great system but it suffers from extreme bloat.
Just MHO of course...
-Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Wolfe | 2001-03-30 20:07:11 | Re: Re: Memory Tuning |
| Previous Message | Bruno Wolff III | 2001-03-30 19:33:45 | Re: Memory Tuning |