Tracking: support pgAdmin 4

[lmatz]

Actions to test:

• connect to RisingWave server
• list all databases
• list all schemas inside a database (current progress branch)
• list all tables inside a schema

Issues:

• support client_min_messages #11048
• support set_config #11146
• feat(config): add bytea_output support (only hex) #11160
• Invalid value ["utf-8"] for ["CLIENT_ENCODING"] #11181
• frontend: support array constructing subquery array(select ...) #11202
• system functions
  • pg_is_in_recovery() -> false
  • pg_is_wal_replay_paused() -> false
  • has_schema_privilege
  • has_table_privilege
  • aclexplode (setof record)
• session configs
  • lc_collate -> C
  • lc_ctype -> C
  • default_tablespace -> empty string
• pg_catalog
  • pg_user.usename
  • pg_database.oid expected to be > 16383
    • workaround: enable show system objects and show template databases in pgAdmin, and create a new database in RisingWave other than dev
  • pg_shseclabel
  • pg_default_acl
  • pg_db_role_setting
• Warning on version older than PostgreSQL 10
• CAST( AS oid)
• Subquery can not be unnested in WHERE EXISTS(... LIMIT 1) #11292

[xiangjinwu]

Pausing the effort in favor of DBeaver. There are numerous dependencies on pg internal catalogs and functions for each click #2954. We'd better focus on one tool first.