Re: ERROR: column c.relhasoids does not exist in Postgres 13

Hi,

I did search in google. I am not getting the steps to upgrade the psql
client alone. Not sure how to get this done. Please advise.

Thanks

Thanks,
Goti

On Tue, Apr 13, 2021 at 11:44 AM Goti <aryan(dot)goti(at)gmail(dot)com> wrote:

> Hi Satish,
>
> Thanks for the quick response. I am sorry I am new to postgres. Can you
> guide me through the steps?
> Thanks,
> Goti
>
>
> On Tue, Apr 13, 2021 at 11:33 AM Satish Nayak [NMC - IT] <
> satish(dot)nayak(at)nmc(dot)ae> wrote:
>
>> Hi ,
>>
>> Please upgrade your client plsql to latest version.
>>
>> Regards ,
>> Satish
>>
>> Get Outlook for iOS <https://aka.ms/o0ukef>
>> ------------------------------
>> *From:* Goti <aryan(dot)goti(at)gmail(dot)com>
>> *Sent:* Tuesday, April 13, 2021 10:00:10 AM
>> *To:* pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
>> *Cc:* Rakesh T <aryan(dot)goti(at)gmail(dot)com>
>> *Subject:* ERROR: column c.relhasoids does not exist in Postgres 13
>>
>> ***This email was sent from a source outside of NMC***
>> Do NOT ACT on any instructions given on email unless you recognize the
>> Sender, If in doubt please contact the Sender directly for confirmation.Do
>> not click on links or open attachments unless you recognize the sender.
>>
>>
>> Hi All,
>>
>> I am getting the below error when trying to describe the table. The
>> postgres version is 13. Appreciate if some help to fix this issue.
>>
>> postgres.practice.com
>> <https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpostgres.practice.com%2F&data=04%7C01%7Csatish.nayak%40nmc.ae%7Cf20304fa877d4b28b82908d8fe417793%7Ca641b6d715cd4d0084d1f5c3903fc026%7C0%7C0%7C637538904859971520%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=jvJ4e9uBXtQR0o4H18x5JCMFhybN7eLaDNG0Du2I37g%3D&reserved=0>
>> {/home/postgres}: postgres -V
>> postgres (PostgreSQL) 13.1
>>
>> postgres.practice.com
>> <https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpostgres.practice.com%2F&data=04%7C01%7Csatish.nayak%40nmc.ae%7Cf20304fa877d4b28b82908d8fe417793%7Ca641b6d715cd4d0084d1f5c3903fc026%7C0%7C0%7C637538904859971520%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=jvJ4e9uBXtQR0o4H18x5JCMFhybN7eLaDNG0Du2I37g%3D&reserved=0>
>> {/home/postgres}: psql -V
>> psql (PostgreSQL) 9.2.24
>>
>> forumdb=# \dt
>> List of relations
>> Schema | Name | Type | Owner
>> --------+--------------+-------+----------
>> public | categories | table | postgres
>>
>> (5 rows)
>>
>> forumdb=# \d categories
>> ERROR: column c.relhasoids does not exist
>> LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoi...
>>
>>
>>
>> Thanks,
>> Goti
>> 'Classification: Restricted
>> On 27 September 2020 a number of the entities of the NMC Healthcare group
>> were placed into administration under Abu Dhabi Global Market Regulations.
>> Richard Fleming and Ben Cairns have been appointed Joint Administrators in
>> this regard to manage the affairs, business and property of the relevant
>> companies in administration as agents without personal liability. In that
>> capacity the Joint Administrators have delegated certain powers to the
>> board of directors to act as agents of the relevant companies. For full
>> information regarding these appointments please redirect to this web page:
>> https://nmc.ae/
>> This e-mail message including any attachments is intended solely for the
>> addressee(s) and may contain privileged information. If you have received
>> this email by mistake, please notify the sender and delete the message
>> destroying any hard copies of the original message. This message does not
>> contain financial instructions or commitments of any kind. Any views
>> expressed in this message are those of the individual sender. NMC accepts
>> no liability for any damage caused by any virus/worms transmitted by this
>> email..
>>
>