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

Thanks I was able to get this fixed by following the below..

https://serverfault.com/questions/618435/which-package-to-upgrade-psql-client

Thanks,
Goti

On Tue, Apr 13, 2021 at 12:10 PM Goti <aryan(dot)goti(at)gmail(dot)com> wrote:

> 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..
>>>
>>