Use Postgres built-in uuid 4 function rather than an extension

[dantownsend]

Postgres now has gen_random_uuid for creating UUID v4 values, without needing an extension.

Try and move over to this.

Related to #1284

[sinisaos]

Completed in #1323