[lazide]

This doesn’t really help you in this case, because the patch is to generate the UUIDs in the database?

[welder]

Now you can use PG to generate the UUIDv7 in the beginning then easily switch to generating in the client if you need in the future, but I think OP was talking about UUID vs auto-incrementing integer in general not specific to Postgres.

[lazide]

IMO it’s always been easier to generate them in the client. Every major platform has had libraries since forever.