BUG #15881: \d name_of_any_table_in_any_database produces ERROR

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

Sergei Kornilov,
Here is how I configured 12beta2:

LocalWeather=# SELECT * FROM pg_config;
name | setting
-------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BINDIR | /usr/local/pgsql12beta2/pgsql12beta2/bin
DOCDIR | /usr/local/pgsql12beta2/pgsql12beta2/share/doc
HTMLDIR | /usr/local/pgsql12beta2/pgsql12beta2/share/doc
INCLUDEDIR | /usr/local/pgsql12beta2/pgsql12beta2/include
PKGINCLUDEDIR | /usr/local/pgsql12beta2/pgsql12beta2/include
INCLUDEDIR-SERVER | /usr/local/pgsql12beta2/pgsql12beta2/include/server
LIBDIR | /usr/local/pgsql12beta2/pgsql12beta2/lib
PKGLIBDIR | /usr/local/pgsql12beta2/pgsql12beta2/lib
LOCALEDIR | /usr/local/pgsql12beta2/pgsql12beta2/share/locale
MANDIR | /usr/local/pgsql12beta2/pgsql12beta2/share/man
SHAREDIR | /usr/local/pgsql12beta2/pgsql12beta2/share
SYSCONFDIR | /usr/local/pgsql12beta2/pgsql12beta2/etc
PGXS | /usr/local/pgsql12beta2/pgsql12beta2/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE | '--prefix=/usr/local/pgsql12beta2/pgsql12beta2' '--exec-prefix=/usr/local/pgsql12beta2/pgsql12beta2' '--with-perl' '--with-python' '--with-pgport=5442' '--with-bonjour' '--enable-debug' '--with-tcl' '--with-tclconfig=/Library/Frameworks/Tcl.framework/Versions/8.6' '--with-openssl' '--with-includes=/usr/local/include/openssl' '--with-libraries=/usr/libssl.dylib:/usr/lib/libapple_crypto.dylib:/usr/local/lib/libcrypto.a' 'LDFLAGS=-L/usr/local/opt/openssl/lib' 'CPPFLAGS=-I/usr/local/opt/openssl/include'
CC | gcc
CPPFLAGS | -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.14.sdk -I/usr/local/opt/openssl/include -I/usr/local/include/openssl
CFLAGS | -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -g -O2
CFLAGS_SL |
LDFLAGS | -L/usr/local/opt/openssl/lib -Wl,-dead_strip_dylibs
LDFLAGS_EX |
LDFLAGS_SL |
LIBS | -lpgcommon -lpgport -lssl -lcrypto -lz -lreadline -lm
VERSION | PostgreSQL 12beta2
(23 rows)

Note the VERSION is PostgreSQL 12beta2.
Regards,
Cliff Campo

Hi

I am not asking about the postgresql server. I am asking about the psql version (client). Do you run psql from /usr/local/pgsql12beta2/pgsql12beta2/bin/psql ?

regards, Sergei

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 28 Jun 2019, at 14:55, c Campo <cc@cj3.cc> wrote:

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.

The documentation states this in Notes section for psql:

"psql works best with servers of the same or an older major version.
Backslash commands are particularly likely to fail if the server is of
a newer version than psql itself. However, backslash commands of the
\d family should work with servers of versions back to 7.4, though not
necessarily with servers newer than psql itself."

See https://www.postgresql.org/docs/12/app-psql.html for reference.

cheers ./daniel

On 2019-Jun-28, c Campo wrote:

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,

Older versions work, but some specific features don't. This is
expected, known, and the only way to allow things to move forward.

then postgres is ok; if not, then there is a problem. If the intension
is the former, then documentation should state so.

It seems okay. This is what psql says that when you connect:

WARNING: psql major version 9.6, server major version 12.
Some psql features might not work.

It seems very clear to me, but maybe I'm just too used to it.

--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services