pgwire: Add SEVERITY_NONLOCALIZED error field

[dvarrazzo]

Is your feature request related to a problem? Please describe.

Since version 9.6, PostgreSQL emits a SEVERITY_NONLOCALIZED field with its error messages (code is V). This field is missing in CRDB.

>>> import psycopg
>>> conn = psycopg.connect("postgresql://root@localhost:26257/defaultdb?sslmode=disable")
>>> try:
...     conn.execute("select wat")
... except Exception as e:
...     ex = e

>>> ex.diag.severity
'ERROR'  # This might be in another language

>>> ex.diag.severity_nonlocalized
None

Describe the solution you'd like

Please introduce this field, as it might be used by clients to decide what to do with a notification.

It needs to be added here:

cockroach/pkg/sql/pgwire/conn.go

Line 1475 in daf3b48

msgBuilder.writeTerminatedString(pgErr.Severity)

Jira issue: CRDB-16071

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/sql-experience (found keywords: libpq)
• @cockroachdb/bulk-io (found keywords: import)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[blathers-crl]

cc @cockroachdb/bulk-io