Search Postgresql Archives

Re: Weird procedure question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Tue, Sep 25, 2018, 2:19 AM digimer <lists@xxxxxxxxxx> wrote:

Oooooh, this is a very interesting approach! I didn't realize any UUIDs could be created in a predictable way. Thank you, this might be what I need.

Yep, DCE defined about 5 different versions of UUIDs, each with somewhat differing characteristics.

https://en.m.wikipedia.org/wiki/Universally_unique_identifier

Versions 3 and 5 generate repeatable values, which is possibly what you are after.

1 and 2 used timestamp info plus node.  At one time MAC addresses were used as node info, but that seems to have fallen into disrepute.  (I think because it leaks network identifier info)

It's worth struggling through understanding them; the variations certainly are useful.

I think I have a function around to generate time-based UUIDs based on giving the timestamp as parameter; I'll see if I can dig that out.  That would allow writing up old history with UUIDs that look old.  Bug me off list if that sounds interesting.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux