According to postgresql uuid-ossp documentation uuid_generate_v1()
is based on Mac address + timestamp:
https://www.postgresql.org/docs/9.4/static/uuid-ossp.html
On a distributed database scenario where we have hundreds of databases generating records with UUID keys and syncing back to a central database.
Suppose we detect a machine has a wrong date/time in the future and we change it back to the correct date/time. May it generate a conflicted UUID key on this particular machine?
One scenario is the summer time / daylight savings.