Request a Demo
Home   >   mailing lists

Re: uuidv7 improperly accepts dates before 1970-01-01 - Mailing list pgsql-hackers

From Zsolt Parragi
Subject Re: uuidv7 improperly accepts dates before 1970-01-01
Date
Msg-id CAN4CZFP9XsTXijqxtK7v9Hgad3jQN-m+wBve0azdi3QkheJv7Q@mail.gmail.com
Whole thread
In response to Re: uuidv7 improperly accepts dates before 1970-01-01  (Baji Shaik <baji.pgdev@gmail.com>)
Responses Re: uuidv7 improperly accepts dates before 1970-01-01
List pgsql-hackers
Tree view 
Hello!

`us` can overflow and while it still results in an error, it is in the
wrong direction:

SELECT uuidv7('292230 years'::interval);
ERROR:  timestamp out of range for UUID version 7
DETAIL:  UUID version 7 does not support timestamps before the Unix epoch.

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Adding basic NUMA awareness
Next
From: Zsolt Parragi
Date:
Subject: Re: glob support in extension_control_path/dynamic_library_path?