sql: collation using pg_catalog.default does not work

[fqazi]

Currently CRDB does not support the builtin collation pg_catalog.default, which makes it incompatible with PostgresSQL. For example we support the following:

select 'a' < ('foo' COLLATE default);

but on Postgres the following is valid syntax as well.

select 'a' < ('foo' COLLATE pg_catalog.default);

Jira issue: CRDB-38613

Epic CRDB-37763

[rafiss]

We might need to update the syntax rule for collation names here:

cockroach/pkg/sql/parser/sql.y

Line 16721 in c1828e7

collation_name: unrestricted_name

[marksoper]

Also part of the original customer feedback: the original SQL that was not working was generated by the \d <table_or_view_name> command. So the customer is not just saying "hey this SQL doesn't work", but also "why does the describe command produce SQL that doesn't work".