pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit"
5+ messages / 4 participants
[nested] [flat]

* BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit"
@ 2021-01-28 05:48 PG Bug reporting form <noreply@postgresql.org>
  2021-01-28 08:40 ` Re: BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" Sergei Kornilov <sk@zsrv.org>
  0 siblings, 1 reply; 5+ messages in thread

From: PG Bug reporting form @ 2021-01-28 05:48 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: ajaycc@gmail.com

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit"
  2021-01-28 05:48 BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" PG Bug reporting form <noreply@postgresql.org>
@ 2021-01-28 08:40 ` Sergei Kornilov <sk@zsrv.org>
  2021-01-28 08:54   ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Ajay Chitale <ajaycc@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Sergei Kornilov @ 2021-01-28 08:40 UTC (permalink / raw)
  To: ajaycc@gmail.com <ajaycc@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

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





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
  2021-01-28 05:48 BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" PG Bug reporting form <noreply@postgresql.org>
  2021-01-28 08:40 ` Re: BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" Sergei Kornilov <sk@zsrv.org>
@ 2021-01-28 08:54   ` Ajay Chitale <ajaycc@gmail.com>
  2021-01-28 09:06     ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Magnus Hagander <magnus@hagander.net>
  0 siblings, 1 reply; 5+ messages in thread

From: Ajay Chitale @ 2021-01-28 08:54 UTC (permalink / raw)
  To: Sergei Kornilov <sk@zsrv.org>; +Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

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.


Thanks

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
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
  2021-01-28 05:48 BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" PG Bug reporting form <noreply@postgresql.org>
  2021-01-28 08:40 ` Re: BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" Sergei Kornilov <sk@zsrv.org>
  2021-01-28 08:54   ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Ajay Chitale <ajaycc@gmail.com>
@ 2021-01-28 09:06     ` Magnus Hagander <magnus@hagander.net>
  2021-01-28 09:36       ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Ajay Chitale <ajaycc@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Magnus Hagander @ 2021-01-28 09:06 UTC (permalink / raw)
  To: Ajay Chitale <ajaycc@gmail.com>; +Cc: Sergei Kornilov <sk@zsrv.org>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

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/





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit"
  2021-01-28 05:48 BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" PG Bug reporting form <noreply@postgresql.org>
  2021-01-28 08:40 ` Re: BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" Sergei Kornilov <sk@zsrv.org>
  2021-01-28 08:54   ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Ajay Chitale <ajaycc@gmail.com>
  2021-01-28 09:06     ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Magnus Hagander <magnus@hagander.net>
@ 2021-01-28 09:36       ` Ajay Chitale <ajaycc@gmail.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Ajay Chitale @ 2021-01-28 09:36 UTC (permalink / raw)
  To: Magnus Hagander <magnus@hagander.net>; +Cc: Sergei Kornilov <sk@zsrv.org>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>

I just installed Postgresql 13 by following below instructions at
https://www.postgresql.org/download/linux/redhat/. It installed the
versions as you see


   1. Select version: 131211109.69.5
   2. Select platform: * Select your platformRed Hat Enterprise, CentOS,
   Scientific or Oracle version 6Red Hat Enterprise, CentOS, Scientific or
   Oracle version 7Red Hat Enterprise, CentOS, Scientific or Oracle version
   8Fedora version 31Fedora version 32Fedora version 33
   3. Select architecture: x86_64ppc64leaarch64
   4. 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.rp...

   # 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/
>

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2021-01-28 09:36 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-28 05:48 BUG #16841: psql  --  \d tablename , displays "Error : column c.relhasoids does not exit" PG Bug reporting form <noreply@postgresql.org>
2021-01-28 08:40 ` Sergei Kornilov <sk@zsrv.org>
2021-01-28 08:54   ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Ajay Chitale <ajaycc@gmail.com>
2021-01-28 09:06     ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Magnus Hagander <magnus@hagander.net>
2021-01-28 09:36       ` Re: BUG #16841: psql -- \d tablename , displays "Error : column c.relhasoids does not exit" Ajay Chitale <ajaycc@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox