Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lWC9I-0004qT-H7 for pgsql-admin@arkaria.postgresql.org; Tue, 13 Apr 2021 06:03:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lWC9H-0003DP-EV for pgsql-admin@arkaria.postgresql.org; Tue, 13 Apr 2021 06:03:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lWC9G-0003CC-U6 for pgsql-admin@lists.postgresql.org; Tue, 13 Apr 2021 06:03:43 +0000 Received: from mail-eopbgr10079.outbound.protection.outlook.com ([40.107.1.79] helo=EUR02-HE1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lWC9D-0000Sp-FG for pgsql-admin@lists.postgresql.org; Tue, 13 Apr 2021 06:03:42 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ipKjF8w3UPIH5pCQMSnazSFD4hkE1T/oWW6c5305Vlc/cDXwhsT5cxJIVouJyevuKh33hvdfYNMO63SdkLiwUZmKHv2rJQpCJBPHznYenEbxrZYG79MVrg8Dq2TL9v5oqbwYM2PC1TRWOdbMAnedWmbxYb0MJaGUlCcDZ2gLHYLTWPuqTk4EwyFS/LzbdtXS7Fp9xYV1ofRKjh63jVzBdJgpBriBa519sp9WxJraKJdEWAV7bgLdAYU+fr+4xFoQR6AkS5pIDax0LA0Mkpn+XcmkLBEqCG3vR0qStIWrTpj9hU92a7KHLaNLYxwhgPMfahqq9zIS2F8yiwsxWbh49A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=lX0rB5RbVH6bhM/Ps2GOj0PsXYosNlG79trp1pouQuE=; b=m/BjAWfFU4dCeyCZgdrUj5nGD6btiWoaRVmhxnWsZO1MPNW0najCMGSFfi+pQXkFaqVTWvVbybZtSZMh7l9JAKT8EFWcHKanPqZmAp1cf3mZCgZwLk6Iyr8E/TTe7q5NbfN9RDpTurR+s32iiSbfTgqChx3P1Giz0A3L6hEPcYa77a7rQD6WvrYLvdF8yt9EZGyLAmxDr1QH7IpUvlJU2R8eBwzOaFCrhAhH3DGLl9yPeIddkGI0QFnEngbDMfkPDSORXYRSNHQ+4M7CwTINCpk0lbokHwUNEdr6Dglir02jV8wySxVQmlpHmDe8XeRXR7datAFYpuj4FlJfWX8QlQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=nmc.ae; dmarc=pass action=none header.from=nmc.ae; dkim=pass header.d=nmc.ae; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nmc.ae; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=lX0rB5RbVH6bhM/Ps2GOj0PsXYosNlG79trp1pouQuE=; b=TkIjNUb0HaB9Ee0yIuRH4LqnkRpezOekn81Gag5ZNhtXfKNV/FGoLadCy+3wZ4PhxjosUzcLeAPMq5vNDVY3fV07lYbjurUy6SdkQCoEru1xY5v9DPHoYUPaigBGFbKwvQ6oNAXcrP4isdMG19u2os7B0XPgCxQ+Fsc7genYH+4= Received: from AS8PR10MB4805.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:20b:337::22) by AM6PR10MB2389.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:20b:4c::25) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4020.18; Tue, 13 Apr 2021 06:03:37 +0000 Received: from AS8PR10MB4805.EURPRD10.PROD.OUTLOOK.COM ([fe80::ad9f:5a24:5f7:9cdd]) by AS8PR10MB4805.EURPRD10.PROD.OUTLOOK.COM ([fe80::ad9f:5a24:5f7:9cdd%3]) with mapi id 15.20.4020.022; Tue, 13 Apr 2021 06:03:37 +0000 From: "Satish Nayak [NMC - IT]" To: Goti , "pgsql-admin@lists.postgresql.org" CC: Rakesh T Subject: Re: ERROR: column c.relhasoids does not exist in Postgres 13 Thread-Topic: ERROR: column c.relhasoids does not exist in Postgres 13 Thread-Index: AQHXMCpwC3Ms2CSUKE6V6u1hMjY2V6qx9Ncr Date: Tue, 13 Apr 2021 06:03:37 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: gmail.com; dkim=none (message not signed) header.d=none;gmail.com; dmarc=none action=none header.from=nmc.ae; x-originating-ip: [2.50.152.234] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 99fb898c-69ed-410e-f8e0-08d8fe41e0f1 x-ms-traffictypediagnostic: AM6PR10MB2389: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:5797; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 7R2xappFVkpQj78Ohx6EO7iPn/DZ7/kT5EcXLPcIObpOgyWBykiK/iYr/c9TwENlYRzNGuzG8ZVwkph6A2YydmWHeb0vaWILDbtN8OXgrWUcKEevQHvIG440Tgs2BzCvZu0zoXhLuU+Nr65ldbEWWKJ1z3a4UdzILsoZaNZPctCkkSKXk7dPf5HPARUAjwucAYsbGGZ9PJ38sg24P9qH04+PmoZe3vjTLG77getr0GSXB73sdZ/HQVp/6YexOoG3Wo+wVHXYzl4qDM7dsn7F0hwNCWDK5p7ngiGTeAogcy1NZJ6D6M3P1bxGQOiv8TfdRtRqaEx5R2qqJ/8evLP7hINnhTG51pcT9pCKjqtNVKBUpZ3MLcv+3ERMeR+Eg4xQohWHYc2JhL39nHecnYesax4kyCyz45ThlhDhddkazTKWNBvcmFq5ZVw+Ls/zqCuj5zQgQMWayZpA4slOvm+8WT3xNiqiUg3JImoPJ/RYAAInP6OqKtmAUr/TD0A6UGz2RbOcEojPZmDs9C4SgM6hbIpWTeX/koxH07vBV5KM7WtsAMUGMMH33h+9Du9zBQiUnpu6W6z/wKHorMXHzl+l/TQpHffi8gFfweUODxAtjawYGG9HPJIL5JNy1hboijjgeMuo+pCaffADWo8uIc+E7PZh/ZMSunmZpnGs+6ualLLn5t72mPDHz8rr06/uWTjT x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AS8PR10MB4805.EURPRD10.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(4636009)(39840400004)(346002)(396003)(136003)(366004)(376002)(110136005)(52536014)(2906002)(316002)(166002)(478600001)(83380400001)(122000001)(33656002)(45080400002)(66574015)(7696005)(91956017)(86362001)(4326008)(5660300002)(53546011)(64756008)(66446008)(186003)(26005)(38100700002)(76116006)(8936002)(6506007)(9686003)(55016002)(8676002)(66556008)(66946007)(71200400001)(66476007)(966005);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata: =?us-ascii?Q?B0IV/mzzoUYvRkY4jvHgj8cM20SzyS1YoOMe1yE3g5Zw6zUg4VREVOVnpzIh?= =?us-ascii?Q?q7LdXIu7RTfHDY+nkYQJWSucYa2JANxk25LkS5zjNkVybPF3hE0RmHKkJ03b?= =?us-ascii?Q?BkjEuRp47lG2ICgneZkHwyWxe+ble20ssmfCzEJWNCyO8mIImeOgbwjEIuTT?= =?us-ascii?Q?Oljzt2j6xrH3/fw3SKG7lWBuCh7W9QF8oj58PPJE062frJzgYpY0gRPQWq8K?= =?us-ascii?Q?9xVh3qaCtmydGMCF4FdNr098gcZEIumhRaBYiBJmJccmWtnNyCR4XP1VZ5mr?= =?us-ascii?Q?mrn9tEXFt85SxB/Rvjb47AaHIJQSsd6DoBYZvuZdolHPt9PK/Vk/CPkx3OjL?= =?us-ascii?Q?Y3s/1FyETjRNLlVX0NaDS5SrUi+tA9/YKSqLmvL0wMVBqR8YCK2o13Eyfahm?= =?us-ascii?Q?3KjdPMFOwcR2a/f39VG/EOtQPFOskhhIM1F9AljI8N0FxkjdDybR+O1JTmCc?= =?us-ascii?Q?HvY+mYquXuTqJQcAV3ItqmytQh3S22GipLXUL90ST+mr6LblxEKlx9t/HOBi?= =?us-ascii?Q?G5Z/pEVSzkBZx+4+ww3QDH9BC1YKB4mmjkY7h6oONkw2QL2/p3Q6CFlpYSju?= =?us-ascii?Q?4EXj5kLfZo9cOqByfA/kyqi8nYj+58OJIsu0vwhKkHsLV87qe856QLqDANFE?= =?us-ascii?Q?PH6+klz1VDrUQVRqLPTVbGk8Lugtsxf5IFxMqkHGhTw4G3ez6wZ7E1bv2FfV?= =?us-ascii?Q?K3eetmQFCXUJIGQf8bIfg9u2m5FFr65m2DRiMDbACHkrwMB+NPIw8TuAcQGB?= =?us-ascii?Q?xKZM3KcPdUAKK8xOPS8L+LRSur8d/hLA14bTbRZ008kUys7TaprDqF5uS02w?= =?us-ascii?Q?LAktlVurefuFhqQ7XuwNpI4qPReLLp0Wu3PJk2pE9/2kOMI52PJ80j4uTUws?= =?us-ascii?Q?EXW1By3F4KxLVNCxboGKXEPJZcopajSpzegd7Das5r6nR3YmAykLUfHyvbvF?= =?us-ascii?Q?doCF0xVqX3epFn3XcR1mm16OSyCK2j67gKItBmJy8wmOVl0obuwTUVV+cF83?= =?us-ascii?Q?LWhXdhjcxO1nK3xAp9f8U0H0ayjhmLaNw523sDAb0aK+suwiJyAwUSwombxn?= =?us-ascii?Q?NoEyNFsi2AecUftuPuHHt0NtCBOXK7hDWMEo8zaUGaRbOKhylf+gKLpl/jPW?= =?us-ascii?Q?F0gn1p8L6ojb/7tVmARUE/wR/N0hGwqvAd3xoECcAR+z641c0eFen6bvSpFJ?= =?us-ascii?Q?wDXZY4m9CbvFzdGKaw4zf3stLlodX6wuNpwug21pwkY7NQ1vpbkJQd0mnaHx?= =?us-ascii?Q?JpwjzrPehj9fiMa1yzzYl/Dx72z5mqgI+pUgts2bNFBpKk4Ro+AtXaE0siu3?= =?us-ascii?Q?Gw607sTQDwkWf19X76q8MGCf0IbI3aKkTlZ6DsL+YMUAdA=3D=3D?= x-ms-exchange-transport-forked: True Content-Type: multipart/alternative; boundary="_000_AS8PR10MB4805F2062B9091AE9FA33336F64F9AS8PR10MB4805EURP_" MIME-Version: 1.0 X-OriginatorOrg: nmc.ae X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AS8PR10MB4805.EURPRD10.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 99fb898c-69ed-410e-f8e0-08d8fe41e0f1 X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Apr 2021 06:03:37.2203 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a641b6d7-15cd-4d00-84d1-f5c3903fc026 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: GVAuzkPdvWvhaYlt2jcLTqtD9Ldz9UvhYVd0fS+DBnp45CeL4iuvBTaJUGZKJ3apDcMYXhGvRpDDbOn4H/w2fw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM6PR10MB2389 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_AS8PR10MB4805F2062B9091AE9FA33336F64F9AS8PR10MB4805EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi , Please upgrade your client plsql to latest version. Regards , Satish Get Outlook for iOS ________________________________ From: Goti Sent: Tuesday, April 13, 2021 10:00:10 AM To: pgsql-admin@lists.postgresql.org Cc: Rakesh T 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 Send= er, 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 postgre= s version is 13. Appreciate if some help to fix this issue. postgres.practice.com {/home/postgres}: postgres -V postgres (PostgreSQL) 13.1 postgres.practice.com {/home/postgres}: psql -V psql (PostgreSQL) 9.2.24 forumdb=3D# \dt List of relations Schema | Name | Type | Owner --------+--------------+-------+---------- public | categories | table | postgres (5 rows) forumdb=3D# \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 w= ere placed into administration under Abu Dhabi Global Market Regulations. R= ichard Fleming and Ben Cairns have been appointed Joint Administrators in t= his regard to manage the affairs, business and property of the relevant com= panies in administration as agents without personal liability. In that capa= city 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 ad= dressee(s) and may contain privileged information. If you have received thi= s email by mistake, please notify the sender and delete the message destroy= ing any hard copies of the original message. This message does not contain = financial instructions or commitments of any kind. Any views expressed in t= his message are those of the individual sender. NMC accepts no liability fo= r any damage caused by any virus/worms transmitted by this email.. --_000_AS8PR10MB4805F2062B9091AE9FA33336F64F9AS8PR10MB4805EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Hi ,

Please upgrade your client plsql  to latest version.

Regards , 
Satish 

Get Outlook for iOS
From: Goti <aryan.goti@g= mail.com>
Sent: Tuesday, April 13, 2021 10:00:10 AM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresq= l.org>
Cc: Rakesh T <aryan.goti@gmail.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 un= less you recognize the Sender, If in doubt please contact the Sender direct= ly 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 postgre= s version is 13. Appreciate if some help to fix this issue.

postgres.practice.com {/home/postgres}: postgres -V
postgres (PostgreSQL) 13.1

postgres.practice.com {/home/postgres}: psql -V
psql (PostgreSQL) 9.2.24

forumdb=3D# \dt
            List of relations
 Schema |     Name     | Type  |  Owner<= br> --------+--------------+-------+----------
 public | categories   | table | postgres

(5 rows)

forumdb=3D# \d categories
ERROR:  column c.relhasoids does not exist
LINE 1: ..., c.relhasindex, c.relhasrules, c.relhastriggers, c.relhasoi...<= br>



Thanks,
Goti
'Classification: Restri= cted
On 27 September 2020 a number of the entities of t= he NMC Healthcare group were placed into administration under Abu Dhabi Glo= bal 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 admi= nistration 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 companie= s. For full information regarding these appointments please redirect to thi= s web page: https://nmc.ae/
This e-mail message including any attachments is intended solely for the ad= dressee(s) and may contain privileged information. If you have received thi= s email by mistake, please notify the sender and delete the message destroy= ing any hard copies of the original message. This message does not contain financial instructions or commitmen= ts of any kind. Any views expressed in this message are those of the indivi= dual sender. NMC accepts no liability for any damage caused by any virus/wo= rms transmitted by this email..
--_000_AS8PR10MB4805F2062B9091AE9FA33336F64F9AS8PR10MB4805EURP_--