[Tracking] Re-triage roachtest failures for closed issues

[rafiss]

Here are the closed issues that still appear as the "cause" of a nightly roachtest failure. It is ordered by frequency that the issue appears as a cause, so we should tackle them in top-to-bottom order.

Count	Owner/Status	Issue	Name	Affected tests
55	@rafiss / In Progress	cockroachdb/cockroach#5807	sql: Add support for TEMP tables	sqlAlchemy libpq pgjdbc
52	TBD	cockroachdb/cockroach#32565	sql: support optional TIME precision	pgjdbc
45	TBD	cockroachdb/cockroach#26097	sql: make TIMETZ more pg-compatible	pgjdbc
8	TBD	cockroachdb/cockroach#6130	sql: add support for key watches with notifications of changes	psycopg
8	TBD	cockroachdb/cockroach#19141	sql: primary keys cannot be changed	pgjdbc
7	TBD	cockroachdb/cockroach#41776	sql: invalid value for parameter "TimeZone": "GMT-08:00"	pgjdbc
6	TBD	cockroachdb/cockroach#41405	sql: cast string to int[] or decimal[] when appropriate	pgjdbc
5	TBD	cockroachdb/cockroach#44711	sql: implement functionality for client_min_messages	psycopg
4	TBD	cockroachdb/cockroach#4035	sql/pgwire: missing support for row count limits in pgwire	pgjdbc
3	TBD	cockroachdb/cockroach#35879	sql: default_transaction_read_only should also accept 'on' and 'off'	psycopg
2	TBD	cockroachdb/cockroach#35902	sql: large object support	psycopg
2	TBD	cockroachdb/cockroach#12137	sql: support SEARCH_PATH variable	libpq
2	TBD	cockroachdb/cockroach#41777	sql: support dollar-quotes	pgjdbc
1	TBD	cockroachdb/cockroach#6583	sql: explicit lock syntax (SELECT FOR {SHARE UPDATE} {skip locked nowait})	psycopg
1	TBD	cockroachdb/cockroach#31113	server: maybe surface unix socket	gopg
1	TBD	cockroachdb/cockroach#44701	sql: pg_sleep return type differs from Postgres	psycopg
1	TBD	cockroachdb/cockroach#41771	sql: add getdatabaseencoding() function	pgjdbc

[rafiss]

Focus on re-triaging "simple query not allowed in extended protocol"