Re: BUG #15881: \d name_of_any_table_in_any_database produces ERROR

Also, Sergei,
This problem seems related to connecting using an older version (9.6.10) of PostgreSQL, then doing a connect to 12beta2
via\c - - - 5442
 

wren:~ cjc$ psql -U cjc -p 5436 LocalWeather
psql (9.6.10)
Type "help" for help.

LocalWeather=# \c - - - 5442
psql (9.6.10, server 12beta2)
WARNING: psql major version 9.6, server major version 12.
         Some psql features might not work.
You are now connected to database "LocalWeather" as user "cjc" via socket in "/tmp" at port "5442".
LocalWeather=# \dS+ pg_config
ERROR:  column c.relhasoids does not exist
LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi... 


When I use the 12beta2 version of psql the problem doesn't seem occur:

wren:~ cjc$ /usr/local/pgsql12beta2/pgsql12beta2/bin/psql -U cjc -p 5442 LocalWeather
psql (12beta2)
Type "help" for help.

LocalWeather=# \dS+ pg_config
                       View "pg_catalog.pg_config"
 Column  | Type | Collation | Nullable | Default | Storage  | Description 
---------+------+-----------+----------+---------+----------+-------------
 name    | text |           |          |         | extended | 
 setting | text |           |          |         | extended | 
View definition:
 SELECT pg_config.name,
    pg_config.setting
   FROM pg_config() pg_config(name, setting);

I don't know what postgres intends to use older versions of psql to connect to version 12; if postgres intends with
RELEASEversion 12 to only use version 12 of psql to connect to the version 12 postgres, then postgres is ok; if not,
thenthere is a problem. If the intension is the former, then documentation should state so. 
 
Best,
cjc

> On June 28, 2019 at 7:38 AM Sergei Kornilov <sk@zsrv.org> wrote:
> 
> 
> Hello
> 
> Thank you for report. Can you verify you using psql version 12beta2? You see message like this:
> 
> > ./psql 
> > psql (12beta2)
> > Type "help" for help.
> > 
> > postgres=#
> 
> For example "\d pg_stats" works for me in this case
> 
> Or something like:
> 
> > psql (11.4 (Debian 11.4-1.pgdg100+1), server 12beta2)
> > WARNING: psql major version 11, server major version 12.
> >          Some psql features might not work.
> > Type "help" for help.
> >
> > postgres=#
> 
> Older psql version should give such error, this is expected and we write warning about it.
> 
> regards, Sergei