sql: PGAdmin Testing Investigation

[BramGruneir]

While testing out PGAdmin's test suite, the following issues cause test failures. Note that this is not a list of extensions to implement but a list of what fell out of my investigation into PGAdmin. We will not support a good number of these.

So we should be able to create a subset of tests that we will support (and run) and what we won't.

The most important item to unlock testing is the correct full handling of schemas.

Feature	Issue #	Achievable	Other demand known	Planned	PostgreSQL docs
CREATE USER WITH NOLOGIN		yes (S)	yes		link
CREATE ROLE username LOGIN		yes (S)	yes		link
CREATE DATABASE WITH OWNER		yes (S)			link
CREATE SCHEMA	#26443	yes (M)	yes	probably	link
COMMENT ON DATABASE	#26617	yes (M)	yes		link
CREATE CAST		yes (L)			link
CREATE COLLATION		yes (L)			link
CREATE DOMAIN		yes (L)			link
(fts) CREATE TEXT SEARCH CONFIGURATION		yes (XL)	yes		link
(fts) CREATE TEXT SEARCH DICTIONARY		yes (XL)	yes		link
(fts) CREATE TEXT SEARCH TEMPLATE		yes (XL)	yes		link
(fts) DROP TEXT SEARCH PARSER		yes (XL)	yes		link
(procedures, not stored) DO $$		yes (XXL)	yes (stored procs)	yes	link
row_to_json	#37124	Yes			link
pg_catalog.pg_default_acl	#26378	Yes			link
CREATE EVENT TRIGGER		perhaps (XL)	yes		link
CREATE EXTENSION		prob.no (XXL)			link
CREATE TRUSTED PROCEDURAL LANGUAGE		prob.no (XXL)			link
(fdw) CREATE FOREIGN DATA WRAPPER		no			link
(fdw) CREATE FOREIGN TABLE		no			link
(fdw) CREATE SERVER		no			link
(fdw) CREATE USER MAPPING FOR		no			link
pg_terminate_backend()		no			link

Jira issue: CRDB-4995

[BramGruneir]

@awoods187 Can you look through this list and augment it with what's on our roadmap and what's not?

[knz]

I have created a table above with the detail of the features. I think most of them we will not implement anytime soon. It would be better for now to simply skip these tests.

[vy-ton]

@rafiss I don't believe PGAdmin's test suite is integrated into our CI but it could be one to prioritized. Would be interesting to compare a GUI test suite against the driver and ORM ones

[ozturkberkay]

Hi. I noticed that pg_cancel_backend is also not supported. Are there any alternatives for pg_terminate_backend and/or pg_cancel_backend in CockroachDB?

EDIT: https://www.cockroachlabs.com/docs/v21.2/cancel-session

[vy-ton]

#41335 is coming in 22.1 as well