Thread: using psql 11.4 with a server 13.0 && meta commands
Hello,
I've found the following problem using psql 11.4 against a server 13.0:
$ export LANG=en_US.UTF-8
$ psql -Usisis -dsisis
psql (11.4, server 13.0)
WARNING: psql major version 11, server major version 13.
Some psql features might not work.
Type "help" for help.
sisis=# \d dbctest
FEHLER: Spalte c.relhasoids existiert nicht
LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi...
^
sisis=#
Is this expected? Are there other bigger issues with commands. I see the
message "Some psql features might not work.", but that this affects also
"normal" commands of daily use...
Thanks
matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Без книги нет знания, без знания нет коммунизма (Влaдимир Ильич Ленин)
Without books no knowledge - without knowledge no communism (Vladimir Ilyich Lenin)
Sin libros no hay saber - sin saber no hay comunismo. (Vladimir Ilich Lenin)
2020年10月21日(水) 20:54 Matthias Apitz <guru@unixarea.de>: > > > Hello, > > I've found the following problem using psql 11.4 against a server 13.0: > > $ export LANG=en_US.UTF-8 > $ psql -Usisis -dsisis > psql (11.4, server 13.0) > WARNING: psql major version 11, server major version 13. > Some psql features might not work. > Type "help" for help. > > sisis=# \d dbctest > FEHLER: Spalte c.relhasoids existiert nicht > LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi... > ^ > sisis=# > > Is this expected? Are there other bigger issues with commands. I see the > message "Some psql features might not work.", but that this affects also > "normal" commands of daily use... Yes, this is fully expected - the system catalogue may change between server versions, and hence the SQL needed for the meta-commands. Any psql version should be backwards- compatible with older server versions, but older psql versions cannot of course know what SQL might needed for newer server versions. Hence the warning. Regards Ian Barwick -- EnterpriseDB: https://www.enterprisedb.com
On 10/21/20 4:54 AM, Matthias Apitz wrote: > > Hello, > > I've found the following problem using psql 11.4 against a server 13.0: > > $ export LANG=en_US.UTF-8 > $ psql -Usisis -dsisis > psql (11.4, server 13.0) > WARNING: psql major version 11, server major version 13. > Some psql features might not work. > Type "help" for help. > > sisis=# \d dbctest > FEHLER: Spalte c.relhasoids existiert nicht > LINE 1: ...riggers, c.relrowsecurity, c.relforcerowsecurity, c.relhasoi... > ^ > sisis=# > > Is this expected? Are there other bigger issues with commands. I see the > message "Some psql features might not work.", but that this affects also > "normal" commands of daily use... https://www.postgresql.org/docs/current/app-psql.html " Meta-Commands Anything you enter in psql that begins with an unquoted backslash is a psql meta-command that is processed by psql itself. These commands make psql more useful for administration or scripting. Meta-commands are often called slash or backslash commands. " \ commands are a psql feature, so they are potentially affected. > > Thanks > > matthias > -- Adrian Klaver adrian.klaver@aklaver.com
W dniu 2020-10-21 o 13:54, Matthias Apitz pisze: > Hello, > > I've found the following problem using psql 11.4 against a server 13.0: you may install a separate 13.0 psql binary and use that one against the 13.0 server