Обсуждение: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
От
PG Bug reporting form
Дата:
The following bug has been logged on the website:
Bug reference: 16841
Logged by: Ajay Chitale
Email address: ajaycc@gmail.com
PostgreSQL version: 13.1
Operating system: centos 7
Description:
created a table in psql after connecting to mydb database as
CREATE TABLE tab1(
ID INT PRIMARY KEY NOT NULL);
after a i connect to database using psql and execute "\d tab1" I get
following message
mydb=# \d tab1
ERROR: column c.relhasoids does not exist
LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoi...
^
Should display tables column information
Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
От
Sergei Kornilov
Дата:
Hello Please check your psql version. I think you have a warning like this when starting psql: > WARNING: psql major version ..., server major version 13. > Some psql features might not work. regards, Sergei
Hi,
Yes, I get that message
bash-4.2$ psql mydb
could not change directory to "/home/postgresql"
psql (9.2.24, server 13.1)
WARNING: psql version 9.2, server version 13.0.
Some psql features might not work.
could not change directory to "/home/postgresql"
psql (9.2.24, server 13.1)
WARNING: psql version 9.2, server version 13.0.
Some psql features might not work.
On Thu, Jan 28, 2021 at 2:10 PM Sergei Kornilov <sk@zsrv.org> wrote:
Hello
Please check your psql version. I think you have a warning like this when starting psql:
> WARNING: psql major version ..., server major version 13.
> Some psql features might not work.
regards, Sergei
Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
От
Magnus Hagander
Дата:
On Thu, Jan 28, 2021 at 9:54 AM Ajay Chitale <ajaycc@gmail.com> wrote: > > Hi, > > Yes, I get that message > > bash-4.2$ psql mydb > could not change directory to "/home/postgresql" > psql (9.2.24, server 13.1) > WARNING: psql version 9.2, server version 13.0. > Some psql features might not work. Wow that is.. *very* old. And has been unsupported for many years. You'll want to upgrade your client. On CentOS that will mean installing the package "postgresql13". I'd suggest uninstalling the 9.2 packages while you're at it, so you don't accidentally end up running things from the old versions. -- Magnus Hagander Me: https://www.hagander.net/ Work: https://www.redpill-linpro.com/
I just installed Postgresql 13 by following below instructions at https://www.postgresql.org/download/linux/redhat/. It installed the versions as you see
- Select version:
- Select platform:
- Select architecture:
- Copy, paste and run the relevant parts of the setup script:
# Install the repository RPM: sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm # Install PostgreSQL: sudo yum install -y postgresql13-server # Optionally initialize the database and enable automatic start: sudo /usr/pgsql-13/bin/postgresql-13-setup initdb sudo systemctl enable postgresql-13 sudo systemctl start postgresql-13
On Thu, Jan 28, 2021 at 2:37 PM Magnus Hagander <magnus@hagander.net> wrote:
On Thu, Jan 28, 2021 at 9:54 AM Ajay Chitale <ajaycc@gmail.com> wrote:
>
> Hi,
>
> Yes, I get that message
>
> bash-4.2$ psql mydb
> could not change directory to "/home/postgresql"
> psql (9.2.24, server 13.1)
> WARNING: psql version 9.2, server version 13.0.
> Some psql features might not work.
Wow that is.. *very* old. And has been unsupported for many years.
You'll want to upgrade your client. On CentOS that will mean
installing the package "postgresql13". I'd suggest uninstalling the
9.2 packages while you're at it, so you don't accidentally end up
running things from the old versions.
--
Magnus Hagander
Me: https://www.hagander.net/
Work: https://www.redpill-linpro.com/