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