Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKfSp-00BXCO-7I for pgsql-general@arkaria.postgresql.org; Fri, 21 Jun 2024 14:42:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sKfSn-002K2f-FN for pgsql-general@arkaria.postgresql.org; Fri, 21 Jun 2024 14:42:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKfSm-002Jye-SY for pgsql-general@lists.postgresql.org; Fri, 21 Jun 2024 14:42:05 +0000 Received: from mail-dm6nam12on20701.outbound.protection.outlook.com ([2a01:111:f403:2417::701] helo=NAM12-DM6-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKfSj-002QfP-Cg for pgsql-general@lists.postgresql.org; Fri, 21 Jun 2024 14:42:03 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=AKnwE/HT0s/NMQPkAf0ecW6WWvcF4VwYnLI36ELeAGqxKj4UzwdY6nD8Ui/qDzg8Q5Wu95f1qlA1cJFFXokCPO1uHOErP+s3ieSc2r0w34clA/acuZaO5tf/xvaURfd5NvL/6Uprswk2KXop4DDMYAMHh5gXJMniLQyv4bmyInR3hgIb+45227dwwED+ireBLL5B4U8RV73JrKTvky/VeCRZ52LgCSQwh2tXYHM0aidxpEmRB2Ou2+nNRdMv3lUOthIeTEpsDGgr41WeEYvQW6B1anSNOLMoYthBvZ8zvbON+GI27IUquFlCFJzj/ABJSIEK+CkODrud0+VAJhR8TA== 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-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=eydaL/iR8FcOG5GBrj3/pHKyW7JpCiph8EX04z/STQE=; b=jeBqgjiw1jltatx7PPj4Ac1Us2CsUmWCJKMCsM8XsmISApQlsESuu5XoGBdZf07KwC6+k7upE/LO7RN4olJTorxbFpWAQwkBwIxIFhQHajwztZhCATHb7nYbRunMHy4SHrI/iMRWZJLI1Hiww4NeTr/JRLT6zi2/qUXILxoRg5rXa7hc0eo3EoS4yW9eWv/wlFQvUtlBXQQ7tt8u/xYZEQzCh+16HwqiuHpHkNk1RU+afV4JgkQngBiHDbqtbdJxthBXc3w+s3uCQzgxIMINS7Mxst7QCwvMSy8cA6CVKQawsyrP3GirZ8t77kJdqFT2Szc0l3r/HClqCO17nUEpfA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=assistek.com; dmarc=pass action=none header.from=assistek.com; dkim=pass header.d=assistek.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=assistek.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=eydaL/iR8FcOG5GBrj3/pHKyW7JpCiph8EX04z/STQE=; b=jfHBl+EavbvVnQAtEU3VewamB/M5+Hh7paNvq4m3eweoMQfEmmtq6HTXd+vdIAxjxRaPY2MkR7oG6jHlHNQLa8vQ8SDkiOcKgfNqTqv25wZ2L+EIJ4VYzfF192OG1rH+/y0gAbStIGjMqDF+d8T0ic8tmilkJ7Jf/JVffPjFFj8= Received: from LV3PR16MB6001.namprd16.prod.outlook.com (2603:10b6:408:1b6::8) by CH0PR16MB4388.namprd16.prod.outlook.com (2603:10b6:610:f3::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7677.28; Fri, 21 Jun 2024 14:41:55 +0000 Received: from LV3PR16MB6001.namprd16.prod.outlook.com ([fe80::50ce:c55:8baf:fa37]) by LV3PR16MB6001.namprd16.prod.outlook.com ([fe80::50ce:c55:8baf:fa37%5]) with mapi id 15.20.7698.020; Fri, 21 Jun 2024 14:41:55 +0000 From: Maxwell Dreytser To: "pgsql-general@lists.postgresql.org" Subject: RowDescription for a function does not include table OID Thread-Topic: RowDescription for a function does not include table OID Thread-Index: AQHawSk4Ss901jpQLkiyAb/qTIeG1LHM4zoAgAAAzMuAAvnCxIACb2aC Date: Fri, 21 Jun 2024 14:41:55 +0000 Message-ID: References: <3528232.1718682678@sss.pgh.pa.us> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=assistek.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: LV3PR16MB6001:EE_|CH0PR16MB4388:EE_ x-ms-office365-filtering-correlation-id: f56b08c3-f48d-4a08-11b5-08dc92004c07 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230037|366013|376011|1800799021|38070700015; x-microsoft-antispam-message-info: =?iso-8859-1?Q?UXD0+Rx+5ogNDwcQN/826VUgXaHpMWklQpAixhVHsj5Sug8pRDKzKiQ3Eb?= =?iso-8859-1?Q?k7QumS5CEr7pmxXeviJaI0mngZd/ZpwhztpO05Qwe2X10xoW1j4JMh66rm?= =?iso-8859-1?Q?nmdabDVEGt/OjcfvPEV3LabuF+Uo/cPgfWbGS53R0LFkq4BBQnOn4PkNND?= =?iso-8859-1?Q?UNSLHGTZMTIZC895iE+AGwg4Bd22fSQ7XMxO1FJV5j1E/N4XoHrT9vR86Y?= =?iso-8859-1?Q?4o2eXqXNlukGYP1PTINfqv2sdKg6Y1hHLwtZTE6W6fQL9JFtFPRMxxZm71?= =?iso-8859-1?Q?/Q7Mly4f6HHM6SYrBBtic7WucC4xQyVYFRH7JpVo9hXJCQGpqud9yGCBpP?= =?iso-8859-1?Q?zLGpK/I8iuSVgS/lO68JT1dXj6RQO2pIQKL2ztArWBzXqKb9A0n9fcewS+?= =?iso-8859-1?Q?rb/z0HeomT4RHuyFpRe4erlHfWmBYafjlS1G5CdyDa4iFaArztlpHBdXmO?= =?iso-8859-1?Q?JStMwEsl+G7MkFfPEzXkH2L21wsf5G7G30gV/wAl9XEvStu1oUYqHQdeJh?= =?iso-8859-1?Q?hKIqO0k35548tT7yOTdeL276I37GDsv0dLeeBPe7ZUHYtk4RSgNQJ5+ORp?= =?iso-8859-1?Q?6Hgi9+J0FvulYzdCa4pVX2DQcJMXMPapekiIut9f1AP/UrqNLkEBskLWZD?= =?iso-8859-1?Q?5/g9WeBlzA7GyyN8KctP9lCpHRaxLV21BsGMr2klc9d4kU1nvV98zn3M1s?= =?iso-8859-1?Q?JMRCXUkC6CMq2/9hwTMpTIpngqWDIWv3+xVW40TrA8drj474rm85tiyWfM?= =?iso-8859-1?Q?aScnF3891KibesKkmGDgZpePALFSjeEyE89BGosndtcHVvtZ4cUcxcUhxB?= =?iso-8859-1?Q?d7LLghpoS0oSkGFV7AWbLqmuVUvWqt+2DRXe3s7x5OnbNLWzJ8ZHR2/DOQ?= =?iso-8859-1?Q?BfM2XSktzB0nwK8VtrbdzpSsZbgjOzzLdVnKEtzHLKT+J+CBor/pOhaPQY?= =?iso-8859-1?Q?blrUr+0GzNBUAojqy0Zbb+9metuSRPRUROfCVehasDnN8SZeBvoBVXLpz0?= =?iso-8859-1?Q?CtD71lQwFGMad1SH0V8i3w5rb0Tl+H2zcs2EH0L9zs1UjgaC7kdQmz9ij2?= =?iso-8859-1?Q?9IGNhS1Mg4Vqp6PMypPvNNrVfxooF++otsqwPvSeGSiQIQHKlJ2/bBy5Ck?= =?iso-8859-1?Q?WBRPAeqHTaS4FLNU9DuKdaHVSMKHECX3PZ1sI1kK3RIWm8TFzNvF+2tEUO?= =?iso-8859-1?Q?UtKUJBwxG6uwOUuSFjiQRs3h9lZoVz0zJfkQXkfRbs0gjxR/IOTApTDQ1e?= =?iso-8859-1?Q?Y/ViP62w1FmIgo6Gvcp3GGuXT9o56IoEtPe8blJ4XAuolduKK6a//F13Ba?= =?iso-8859-1?Q?juJ4mFF2Y/R1B+a8JABtfCrUj++9Kh6acMkUhuBdZiRMeD2VS6Q2yOX1rk?= =?iso-8859-1?Q?dQz14wxOuR59fN8Fzy4TgXOUmKtSby8amnqiPnK5sCiy4oukOZ64Q=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:LV3PR16MB6001.namprd16.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230037)(366013)(376011)(1800799021)(38070700015);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?PpYfxdEtAEHivYpo5KUFzu2/IYgDrfPIBeuSI9LOSNFthqEnC09tCtc8Jn?= =?iso-8859-1?Q?FpmNi/kNnCkrcm2aMoo6DX2qpJ1I3poUulnZN92IY7CqBqjoyyAmTxbfaf?= =?iso-8859-1?Q?pwXpuGB/gxo0omifOqNX7BX95edwuXfEe+yoKxgRJPDEwni5JFFm1JcjnC?= =?iso-8859-1?Q?QCOrRedWMzS4YK/Q8mMzdmKcDw8wjDzu4uVqozy/VrR9XUphW0zFY0NfWr?= =?iso-8859-1?Q?CN86l5fPscEuzB8fmrRlQmALDEajKJnCVZ2ogjjpZ+3Q/QxBODNFXKcEns?= =?iso-8859-1?Q?JBgkpyteJBZQZBfVWCT4lBNs/nUstLMvWWgMkEwM7f0M71D1QRqr8ubMLD?= =?iso-8859-1?Q?gHXkdN4YtvullmZxT+Wjk/eTeAv2rkKkGSJrEAXtbQEsBVwbZ04YZz/W4N?= =?iso-8859-1?Q?o3asJJeI3nfPkN6TkoPdK+VBBQLSbgrcT7gJ/ph0b2Xc+acjbURkk8B81b?= =?iso-8859-1?Q?iomO2bzXLrLA/TBIJeTUEn3ym2Cr7ww8kKqR1VECHIdsgby9zlqJHleibH?= =?iso-8859-1?Q?lCClxtBJMeEXdv4fn3AKd4N4ee5/VgeapBeGryIKG6sqX/8twxzuUufdRb?= =?iso-8859-1?Q?96jj8xuVXU32rJJKN11GKj/cWWS2v4pOMyWg2nff2421Me4A4LSF+0lVKR?= =?iso-8859-1?Q?Sag69CmLULfYURqT/poqMcvaMgFpJ9xGxzqWI8cA48BGW0tWYLthMONDXN?= =?iso-8859-1?Q?D4DHw60zoqR9sKYNJOEj5WGjneOA24DnkwJHCDGGktumpFVltrdVJAxXKo?= =?iso-8859-1?Q?RZX3t3OGk9/YQ1cVNxI+kEAp5qoy1MKC4JBmIh3bvHuntGzyv1Rhq9K6Hn?= =?iso-8859-1?Q?uiiWLHhKyjGgvIeAZ7OE90czl3Of4qKOVJtnCeRn/0Q4KvehuOeIcQVJvI?= =?iso-8859-1?Q?6dxBKJXUuOXjzuXnUqDw2tcPBZomT6cTuS1OGWLT/1VcsApvrTqYGor9cj?= =?iso-8859-1?Q?PeIGG5zvJUGKjZjYRJpnXB4DyCZKTr60cfdQb5ONlXGKEMqNi+Hep9s/zm?= =?iso-8859-1?Q?+0QYmf8dlV9Xli3uXbDrlzMwK19btD/7g6qZMiGrKDkvblon4CYlpmlj7W?= =?iso-8859-1?Q?6PiaSnE2kb23TdNS+cTiwjXi8twgdwYtrG2RZySa+bPGS0ZQB67a3fKC69?= =?iso-8859-1?Q?454tVyF/tF5a56rthTk3rVZhhpAfFnBR6jHrq2lipLcBm7ex0y0QhiLCiY?= =?iso-8859-1?Q?JR5KMQNYZXL1Q/0rJmHNtfvCeV4X+W7xD7lmu0Bx6am2bEoB3XbBBiFaGs?= =?iso-8859-1?Q?kV0QCTd4DtiwPAZh0Qmj45s17hiDIzNhSiJk4Fshsga6BEe14g/dWh2UvK?= =?iso-8859-1?Q?vCW69rIZkxe3fWogg2n9w4xuvfBo1H1mGKfObq+IIjMmpcRoD4vUBVwUa2?= =?iso-8859-1?Q?CqBTsG0mBkJPZOPH4AoxnCgVLVdBNzTHtf5sf8IMpIaNiIIluVt29SPb94?= =?iso-8859-1?Q?ra+JsqQK4+OUDtnkPgnSeljCRhvAqNKOlQhik0qt2axt95vL0rMiQ9lnmo?= =?iso-8859-1?Q?iY0ELSsh2inAB9XXz8mrxxcoU8Dy561xnzAmT5Oydwp9HMQfsoGS7apqj/?= =?iso-8859-1?Q?BoYAAXyT8XDRCGJrAKQTjTXvaABkuBTrh6mPpAFn4QwB9FXGP/AVyxnUha?= =?iso-8859-1?Q?1Q/Uhf3svS0xO/tAmt86pA602r7SUmO3wrv4glYynDtj4bwhKtCODVIA?= =?iso-8859-1?Q?=3D=3D?= Content-Type: multipart/alternative; boundary="_000_LV3PR16MB60014D610A726368182ACC7EE6C92LV3PR16MB6001namp_" MIME-Version: 1.0 X-OriginatorOrg: assistek.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: LV3PR16MB6001.namprd16.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: f56b08c3-f48d-4a08-11b5-08dc92004c07 X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Jun 2024 14:41:55.2886 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 6163a167-3399-4bf6-885f-4fce6e26edf0 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: F8jjzM71JeCKGJoanNo3DqgSzV5bmibLpwcppvrA4U5y0oMxKggsRfAY/gzDeQtasq9zyZVaCUjEH7cA+CPjdso2PsLNIBkdwiVKw3iQut0= X-MS-Exchange-Transport-CrossTenantHeadersStamped: CH0PR16MB4388 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_LV3PR16MB60014D610A726368182ACC7EE6C92LV3PR16MB6001namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am working on a meta-programming use-case where I need to scrape some det= ailed information about the results of a function that "RETURNS TABLE (LIKE= physical_table)", which ends up with prorettype =3D 'physical_table'::regt= ype. The problem is that for the query "SELECT * FROM my_function()" the RowDesc= ription that is sent back shows 0 for Table OID and Column Index. From Wireshark: PostgreSQL Type: Row description Length: 219 Field count: 7 Column name: table_id Table OID: 0 Column index: 0 Type OID: 20 Column length: 8 Type modifier: -1 Format: Binary (1) I would expect that the Table OID contains the relation OID of this table, = as it would do for a typical statement like "SELECT * FROM my_table". It wo= uld seem there is a bug here that is preventing PostgreSQL from connecting = the dots. Regards, Maxwell. --_000_LV3PR16MB60014D610A726368182ACC7EE6C92LV3PR16MB6001namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,

I am working on a meta-programming use-case where I need to scrape some det= ailed information about the results of a function that "RETURNS TABLE = (LIKE physical_table)", which ends up with prorettype =3D 'physical_ta= ble'::regtype.
The problem is that for the query "SELECT * FROM my_function()" t= he RowDescription that is sent back shows 0 for Table OID and Column Index.=

From Wireshark:
PostgreSQL
    Type: Row description
    Length: 219
    Field count: 7
        Column name: table_id
            Table OI= D: 0
            Column i= ndex: 0
            Type OID= : 20
            Column l= ength: 8
            Type mod= ifier: -1
            Format: = Binary (1)
<snipped>

I would expect that the Table OID contains the relation OID of this table, = as it would do for a typical statement like "SELECT * FROM my_table&qu= ot;. It would seem there is a bug here that is preventing PostgreSQL from c= onnecting the dots.

Regards,
Maxwell.
--_000_LV3PR16MB60014D610A726368182ACC7EE6C92LV3PR16MB6001namp_--