From: | c Campo <cc(at)cj3(dot)cc> |
---|---|
To: | Sergei Kornilov <sk(at)zsrv(dot)org>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15881: \d name_of_any_table_in_any_database produces ERROR |
Date: | 2019-06-28 12:55:47 |
Message-ID: | 999377173.1874996.1561726547944@webmail.networksolutionsemail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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 RELEASE version 12 to only use version 12 of psql to connect to the version 12 postgres, then postgres is ok; if not, then there 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(at)zsrv(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel Gustafsson | 2019-06-28 13:00:09 | Re: BUG #15881: \d name_of_any_table_in_any_database produces ERROR |
Previous Message | Sergei Kornilov | 2019-06-28 12:47:11 | Re: BUG #15881: \d name_of_any_table_in_any_database produces ERROR |