From: Maxwell Dreytser <Maxwell.Dreytser@assistek.com>
To: "pgsql-interfaces@lists.postgresql.org"
	<pgsql-interfaces@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/qTIeG1A==
Date: Tue, 18 Jun 2024 03:18:40 +0000
Message-ID:
 <LV3PR16MB6001AF4D05893E9FF4B3C746E6CE2@LV3PR16MB6001.namprd16.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
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_|DM4PR16MB5070:EE_
x-ms-office365-filtering-correlation-id: 82580257-cf1c-49bc-b2bb-08dc8f455a45
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230037|1800799021|366013|376011|38070700015;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?m/pZE0OVSlHhpyUyFYX2738kMPFuVciyZlvAfvMRaUlQobEfTBgHZUcKSu?=
 =?iso-8859-1?Q?5iiRCeJea2WGA7tk2Zyng23/ZzLgBKrd1U1oSmEdgikMXG70O/BES1CkHM?=
 =?iso-8859-1?Q?CsTdkZBV1HZwR8WpiHyn4UYrebkp1hgXbUD+ahFT8qE0KruLrRr58hWOeM?=
 =?iso-8859-1?Q?uzVskpwaakIPiihO/DtwwRewcwDmOHkkpJwm4eweIKRiL3jRhDbQ/WkfZZ?=
 =?iso-8859-1?Q?PhkFP95roongJyK6O+yLzNu7N/0I5cpaHaxlK50G4xpJcpVXEV90K+otbl?=
 =?iso-8859-1?Q?XiDbK8SZu89mz9QnxZdyPOdOneDSy2yzEJRC/nPP1oSZlOg4tYnw4RIX2B?=
 =?iso-8859-1?Q?VH0Q3WxnD2rHr8C8JmpSCRChND7hGZFCKvQKbAIPU5lt6UzDf67js8eSSV?=
 =?iso-8859-1?Q?4ttrmvXJ5deEzO+0B7bHx+qtfGqFn8n9lV2SGQhkpP2T3Is80Gx6ErGmud?=
 =?iso-8859-1?Q?RDOBb5PC6d7w6elATwVMdMxwS2NyyWDUtDMKuPrqVmO6Zm0qoJ45a+q4EH?=
 =?iso-8859-1?Q?OpRSp1PpG2Qa8M+L2k4ACKMV0TDJlaQ69d+ZlOEGWDjVgiOl1WIdxA7zm3?=
 =?iso-8859-1?Q?Rb4wrXKVe6CJQj2c20AO7Jn62jng5bjld4+dbyklNDTdXVyBd63+8zu5MH?=
 =?iso-8859-1?Q?LPaJ4dM2uYRVoo5lmuvF9Vr/OQI7m2UWbhX0lAaZ2oxL9Nqr0tRKi3grQZ?=
 =?iso-8859-1?Q?3M8tiBb0tpP+P363udwC2LFEmdwtX4KVPLcUpfE2Dt2N/kxulDqrdtEocK?=
 =?iso-8859-1?Q?20PT6RnMui2xRbX0zYgSfcUoH78d5mBpNMqM4X+aGqf9CDI4I/+E1NaHZU?=
 =?iso-8859-1?Q?Ptie5TVqF3ESi+wdfJ4ftDwbC3CwNSle6+ZI4aKqJU/YWEsCzNawGzskIf?=
 =?iso-8859-1?Q?W9ArDSmO2OXDczD52LE2lEnG1eEIzQloC7MOmTXffRZ4U5omENowCkqQGq?=
 =?iso-8859-1?Q?3KKnHTOY2clRWS5XKAWSUTsmyBITq2Zp6W2XDN9A2qoW29ribWrLXnzOjf?=
 =?iso-8859-1?Q?4rUX6SsjCnfa7idyby3/bO1lyGSKUL+RzIKhZv4U1p+d5+cqPXXyOl3ZQI?=
 =?iso-8859-1?Q?9kJIU908utFk/kpTlcpRDU4YKcoi7TqAEycm2DGyAurnYFOkQCcG0M7JQ4?=
 =?iso-8859-1?Q?4dD+POK/FyqoI140micVpDRnjI08PTSiRRiuXVh+rE8HtN/ioeD9j4F5Jy?=
 =?iso-8859-1?Q?hHAtQWTfTNa3iuiqjRwasL/yy10wMF2dIWolSjuDjqE0mk5MxrIkTSO7RE?=
 =?iso-8859-1?Q?Io8SogRrYC7F0o9p2cbCgYUsVoe81jJ6XbadW4GJsClRG6d1vfgPVAEMRm?=
 =?iso-8859-1?Q?xX2C7YAvkejYNo3PuVCO38/aEGG2ulgDvXNVXmJaOayCiaMr3F836YsDHi?=
 =?iso-8859-1?Q?v7feWUXdsbJbQz+Y3/EBJZSCVY5G0Z1n54J2R69TqY15w/0EziYsk=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)(1800799021)(366013)(376011)(38070700015);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?LGzsPlfsuAtjfWmKwIreKQVxFEE51f08u6f02rxOFYp/W4zigw6A7H3VEU?=
 =?iso-8859-1?Q?CH5crY2PvKAePwzIUOVgHB8+5qfo0qh8gqwCHG2KjoSKRVIVZdwSkctL+2?=
 =?iso-8859-1?Q?lOiBBUG9+Byx7JP//LTPRKDmpRXD21MgjQpZbzV+2anRoRxvLezrZcZrxk?=
 =?iso-8859-1?Q?PkgVU76ozcDcdwVLVj8pdP8/FbmvnqV7tI1rA8gQMg/uiFLAPEwSNi1PAa?=
 =?iso-8859-1?Q?2dLxyDsY3OwVab9qF3/XwGm7JIAPg5b57QmYH3gD4S7XQTQLNpma2JIP0B?=
 =?iso-8859-1?Q?RjocJXkX0htnNy2Jlhqv4DaQxxq79haxGv7iJO2t2pqeZM8KQMZ/J7RDAz?=
 =?iso-8859-1?Q?hYzvsNProPu75QVFaPAyxXJdir2elGIgfUxRYamhh6rU25bSJ9b+jdmhXH?=
 =?iso-8859-1?Q?lIGljuYBlOyToaY4+zlLO2CGV81JmXOMeev9YTgs8+npwA3YZb/CJ4KNTY?=
 =?iso-8859-1?Q?aOHGM1Ssq1jM7Kgv1X8YfhzGgNHZXQAu/JoSUf+YdwHTyzOmKI3zNbNZ3d?=
 =?iso-8859-1?Q?bdYcuQGD1znR7VBbxmcYdQs8MrO7EdeSd77vLWdTxK+V7tMH90bT+yKxqa?=
 =?iso-8859-1?Q?pSynm9t55AEsly6YXom4gnIICMvltrcKUL0zH1ps80pSU6+KGZXTDNq2Dr?=
 =?iso-8859-1?Q?u50VwfNPdYHgqAhs222NtolsZxQYtNq4v2f2n48Wq0UbIKdaoMfb4aVup9?=
 =?iso-8859-1?Q?vQ95t+umnLZxvue87qIyvDbi1vHFGKOxgKLfggx0scUqxa4qPs5grUqN+G?=
 =?iso-8859-1?Q?1MPSGqXIe96dYIyndG+K82ctN2T+dwNu4wBAaXeyygDYMzwZM/ucCn+WAQ?=
 =?iso-8859-1?Q?WQCVWVlJYuia7sEHThZZwZJLytxz+Po8rk959PSCSVegk3rIIzDEdk+D8b?=
 =?iso-8859-1?Q?SYn2ZsP6VbCuKUyhcCGDBy2tOhGIyTEZnRHuVDVTWdPlQ2zcFahiEsS2dx?=
 =?iso-8859-1?Q?l7x5nv4DFAMprCViYTypMXAxYeY5T/Y0BmMTKbj3sQwGD9esp0nLVViK/8?=
 =?iso-8859-1?Q?xLZQ5HeT8fakFaTRuXlKuqO36UcbPvsWNVNItYfIMJWZeIVApfLDPbxVnw?=
 =?iso-8859-1?Q?gAmB06mzVbrXaA6NdTGAtJeymP4vGw45M0xtTjx2KIEb0MGmFv533kD7bg?=
 =?iso-8859-1?Q?dhQZDErUE/rcMdQJxCiqxQd2mfflH4cj0TvoPtneBxwueLvT2w23d2X8lK?=
 =?iso-8859-1?Q?Rs8cecRweUjUuRy5sx18/LZe3nIIvlXGJ0T0zz7x4wZxoOSRzasr8e/cmJ?=
 =?iso-8859-1?Q?zgPCosI1xiE0QGTU09r9bE/jfNNCZNqhAG8ZxV2yeGuJuGVUL7+/mfeiEh?=
 =?iso-8859-1?Q?RAgZov22Fs3KTG2uq47suJdNXzDoZ/lpizazzZoLyAfk9mUg9ufQWKMWbL?=
 =?iso-8859-1?Q?QVrZGM38K1CkIIB5tMoE5p6nyMdwvmFJud2dGlcAI7wt5FBbJwqYdUjX2h?=
 =?iso-8859-1?Q?i6F/xmYp/XQZ9PjpjNWuBAWYidRB5qbKEVnce3RV7CoyfCZfvBMc+DQGXs?=
 =?iso-8859-1?Q?6N9qVu3vKeGctAp4nvfw0AMHOWXVwJm3CNKWziItlSxS1XV3GrkF2pTnO4?=
 =?iso-8859-1?Q?gto6sa+AvRlalz9EssdyQcVEL/NdHcI6mNgiliI7z3YYOfjl2EhLcJqcnR?=
 =?iso-8859-1?Q?3aPrexvL8bb14GrVYTSsV67kAANDjAPO4urCXeVUrAAjfuwsPko52Qgg?=
 =?iso-8859-1?Q?=3D=3D?=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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: 82580257-cf1c-49bc-b2bb-08dc8f455a45
X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Jun 2024 03:18:40.9302
 (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: /3kEF5Zgy9Othme2syPZXXEDi0QjJUuRXSzhfitozgckzzALX60wjGWD6au2mYAiY74ySl8wKcBVvaa9vw1DSzidN5VHp7anflPGHisGKPc=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM4PR16MB5070
List-Id: <pgsql-interfaces.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-interfaces@lists.postgresql.org>
List-Owner: <mailto:pgsql-interfaces-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-interfaces>
Archived-At: <https://www.postgresql.org/message-id/LV3PR16MB6001AF4D05893E9FF4B3C746E6CE2%40LV3PR16MB6001.namprd16.prod.outlook.com>
Precedence: bulk

Hello,=0A=
=0A=
I am working on a meta-programming use-case where I need to scrape some det=
ailed information about the results of a function call that "RETURNS TABLE =
(LIKE physical_table)". Unfortunately RowDescription messages don't contain=
 nearly enough information (no nullability). In pg_type the pg_proc.prorett=
ype of this function shows up as a composite type with a valid typrelid. I =
am interested in getting this typrelid in the RowDescription field table OI=
D field and the respective attribute number field. This would allow me to f=
igure out all the necessary information by looking up in pg_attribute.=0A=
=0A=
If this is something that might be accepted, I would be willing to work on =
a patch to implement this change.=0A=
=0A=
Thank you,=0A=
Maxwell.=