Horton

Re: UUID v7

Nikolay Samokhvalov <nikolay@samokhvalov.com>

View thread View on postgr.es
From: Nikolay Samokhvalov <nikolay@samokhvalov.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Andrey Borodin <x4mmm@yandex-team.ru>, Kirk Wolak <wolakk@gmail.com>
Date: 2024-01-22T04:24:31Z
Lists: pgsql-hackers 
The following review has been posted through the commitfest application:
make installcheck-world:  not tested
Implements feature:       tested, passed
Spec compliant:           not tested
Documentation:            tested, passed

Manually tested uuidv7(), uuid_extract_time() – they work as expected. The basic docs provided look clear.

I haven't checked the tests though and possible edge cases, so leaving it as "needs review" waiting for more reviewers

Commits

  1. Fix timestamp overflow in UUIDv7 implementation.

  2. Add UUID version 7 generation function.

  3. Add some UUID support functions