fix(postgresql): add primaryKey option for uuid

[hairmare]

Adds support for creating a uuid field as primary key directly in a create statement using uuid('id', { primaryKey: true }) for PostgreSQL dialects.

For now the option is only implemented for PostgreSQL dialects since it should work for all of them and it's only really an issue for CockroachDB.

As far as i can tell, using uuid('id', { primaryKey: true }).primary() would still work if you need to support other dialects (the primary() would just generate a no-op alter statement).

It's getting late here, so i'll add a docs PR tomorrow. Please let me know if the integration test (or anything else) is too hacky and i'll improve on it.

Fixes #5211

Docs: knex/documentation#419

[intech]

The cockroach dialect needs to be able to set the default value to gen_random_uuid(). The full SQL line looks like this:

UUID PRIMARY KEY DEFAULT gen_random_uuid()

[OlivierCavadenti]

Use instead await notation

[OlivierCavadenti]

Can we select and test tolumn type too ?

[coveralls]

Coverage increased (+0.01%) to 92.237% when pulling 46b8a69 on hairmare:fix/postgresql-uuid-primary-in-create into bb07d42 on knex:master.

[hairmare]

I switched to using await and implemented the column_type check in 3cb450b and added default gen_random_uuid() for the CockroachDB dialect in 9010b3f.

The tests worked locally, can i have another workflow approval here to see if they still work on GitHub Actions?

[hairmare]

I also added docs in knex/documentation#419

[kibertoad]

TS types also need to be updated

[hairmare]

@kibertoad thanks for the hint, types have been added in 46b8a69

I also realised that i had forgotten to register the new CockroachDB unit tests which has now also been fixed.

[kibertoad]

Thank you! I'll publish new version tonight.