From: Maxwell Dreytser <Maxwell.Dreytser@assistek.com>
To: "David G. Johnston" <david.g.johnston@gmail.com>
CC: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: RowDescription for a function does not include table OID
Thread-Topic: RowDescription for a function does not include table OID
Thread-Index: 
 AQHawSk4Ss901jpQLkiyAb/qTIeG1LHM4zoAgAAAzMuAAvnCxIACb2aCgAAEmACAAABm+w==
Date: Fri, 21 Jun 2024 15:03:58 +0000
Message-ID: 
 <LV3PR16MB6001FF31889B0B0DD4EF6476E6C92@LV3PR16MB6001.namprd16.prod.outlook.com>
References: 
 <LV3PR16MB6001AF4D05893E9FF4B3C746E6CE2@LV3PR16MB6001.namprd16.prod.outlook.com>
 <3528232.1718682678@sss.pgh.pa.us>
 <LV3PR16MB6001CD31C5982777BA9BA25EE6CE2@LV3PR16MB6001.namprd16.prod.outlook.com>
 <LV3PR16MB6001216CE02B2D908F9D87ECE6C82@LV3PR16MB6001.namprd16.prod.outlook.com>
 <LV3PR16MB60014D610A726368182ACC7EE6C92@LV3PR16MB6001.namprd16.prod.outlook.com>
 <CAKFQuwY76Jc=6JJOPzAt98RLuGCgCdNnS6syB0T4hF6iA=+uoQ@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwY76Jc=6JJOPzAt98RLuGCgCdNnS6syB0T4hF6iA=+uoQ@mail.gmail.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_|SN4PR16MB4862:EE_
x-ms-office365-filtering-correlation-id: a4121f6e-b210-4236-ee5b-08dc92036094
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?o8ad4jIKiPAfwicBl1AZz0w36CAwWB7TXl1+n4yH03XYFBjO8bsg9doxal?=
 =?iso-8859-1?Q?lvDfDGK50Nq6BL3dkW1vj3g0pHiz4cbPUS7xYPa359RB564SKDGNIYmtFM?=
 =?iso-8859-1?Q?PRbSusTIb+gju4lhQkF0TMCihuqVIDg9yQEGJKx9gRrgwwebdN5BerpATA?=
 =?iso-8859-1?Q?2nGpcLlmySiUEnz6ouWGuIFeZ4qVPlTTiwXqtsGFCCs9Tgg0rZ9BVa/X+A?=
 =?iso-8859-1?Q?4m2bw2KqsXsWoCLGOio14Wk8/LGbgE1SR/FEFsCGuYAa1c5xVrLgVNwZ3+?=
 =?iso-8859-1?Q?D3oaVWu+i8mOtwAjHhFYZp3AKAv9XqILLiZLGpj7ut9yCNNi4tt8ZH9xZV?=
 =?iso-8859-1?Q?4xiswkSnFB8tTBjKKmdwCl3agts1LhZH3LnVvNnStFsWaSvJ1sVVWZ9uPP?=
 =?iso-8859-1?Q?/kdnBhm/vwkseKGTPUffV+TXZUYIF109FFMRQut3/4atiEQO55SRYDnYPf?=
 =?iso-8859-1?Q?qhcHGuFcC56GB+TCZ7TC08lzzc4ariJEcDpu/vOErKKmvW+KIp8FDIna42?=
 =?iso-8859-1?Q?q5TWSZ0aZwBcdqcHUkFSi4X4d7KNMw7aVVfVYO8/Kp6KSBJCaUmMn9p4PR?=
 =?iso-8859-1?Q?RXN0MX7dOaygiu6o6Cijxzyq06RFJFZ9b/UVOyccAv7nD1gqkzuI+q5bcO?=
 =?iso-8859-1?Q?Mm7lHhw4gvxh8NbA9bnmGPt0vfmvJ7q+pqB09+D2G44PJeP17IOVXYskON?=
 =?iso-8859-1?Q?LgQ9shUIY9OqvOS9wAaFaKwyMCPU6xRDfgHcd0HSovSaktoAiJHIVn2ZrR?=
 =?iso-8859-1?Q?DU28eb1R0EdEDPoUCd6nBP73cNmkvQxPxmijjn8MnXSTkebs0Qz6FJbaFR?=
 =?iso-8859-1?Q?NdXf2fx6xKVV6HYkFBVE+T2axTkMt1m9JwD837kd49lFynUqc3eWQ0FAx2?=
 =?iso-8859-1?Q?9EdxBb1bIGLSOXnazw363mE0nS54Di+JTkZv6jQQusxO1Q9AIFGbSctEAq?=
 =?iso-8859-1?Q?hLthjv7/cirem+gRxx2FWli0P0zSrYK5kio+SDFprW9l/TPRLwth6KvNxr?=
 =?iso-8859-1?Q?GNVar9xgn6JeceEjaHacTF4UXF4HbBH00gGxlsBOPry12uEUVfbhINSmqa?=
 =?iso-8859-1?Q?2zS8RuwgeTBV/8NGN4uWAstIKSin9QgVK85tkFFjshA/3GmumXOgt8oeZP?=
 =?iso-8859-1?Q?MHvAcmm5XugieaeASVX89MiEq4xQ6s97f1spiIlKKE/cJy6DPNpmnxVRJq?=
 =?iso-8859-1?Q?DsYzVJBaDxQ3RsnQZSuDyagoLmJYhJ42lRvXTGE1H2y+JI0wmOfK8l84Mp?=
 =?iso-8859-1?Q?QsSOEWU+OKYoTB8BrqLIqzgY0Zr763+yvicZSmeD+WXsZ2BBHGgJrIBvzh?=
 =?iso-8859-1?Q?s2HUORAJ0UFxB/Ms5CXk0pF6G6sO/puyxhj6G6vDpaIPMEVzi3l9UQ0OvV?=
 =?iso-8859-1?Q?mS9eUaqcfZO1IzuqbTuUf4V2m5iNIUBDJI9/1NoQ2l4v3iylzuAtA=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?y7XjSxsGUK9Cd1/6qn38S6yThSSBuFgpFcuY1PcYR7q3IGpqCxChKfrdwL?=
 =?iso-8859-1?Q?skp65OUfyELIAjY78hKpKC4BCOY5V0PaXHIWgZtjca9EXxr8QIqDtJLz+D?=
 =?iso-8859-1?Q?aWZzS1Xj/ETQ474vYuUxTAN9XyMeGhPNMaB2VIEmLIUOkCDPZSCYMDDL1W?=
 =?iso-8859-1?Q?4vtSHidN6ExV8DkKe6sTy3RJRVTRSmdKZIECCwIesVhL+h/9NGta7OpG7U?=
 =?iso-8859-1?Q?S4vrv/Z30XQDPmqzutaHr9VAOUHdj0XrwS67801MQ4WGi2TfiuA4+JR4dq?=
 =?iso-8859-1?Q?NPbHAwn3p3hwbRByf/oF0Jfkhy8VFUgKd2RMRdyVp9uhuXOrMy8iZCmEf2?=
 =?iso-8859-1?Q?9NqqiryE89ECto2OEMqu3EhqXwE4s3ovJZOqU0m6+RGhB8hbYBuDYRvToC?=
 =?iso-8859-1?Q?hcORKiuEysEM/JaOWCxDK9ipRtfhdIojexOgxbztWCtE4cyohCKihQ3b37?=
 =?iso-8859-1?Q?jXAtZkJ/DdRPSUj5xkOG+vI/PLQD6cYWcfMIRW1o83LVTbWFkqs2f6F1Ky?=
 =?iso-8859-1?Q?jtUmvAgnml9Uv4/X1B5E99FEiKwYXM6cSAFDFx3AA4LLOzyOqtT+Srn0+Y?=
 =?iso-8859-1?Q?Lc0q983FrZ2PICMlVIqLhIWmA18zWp2CsdyAJMxvuVv0ijpRzqf6DbDK0D?=
 =?iso-8859-1?Q?gf0cHAJBdUZDR664GlSHEu6UHk5YnEO44+jhPcS6rjbJ/8T9KgFlcskgqo?=
 =?iso-8859-1?Q?XEBl31KSZHoid16cDNnjZRlvXuSF4359lg62XTSM4p92nOWIhK0kyUkV7g?=
 =?iso-8859-1?Q?16bvX8T9Jbxor8NydkKRDjctmCVt+gNZ23oZtf5jfrm+YduKzPge3srjWT?=
 =?iso-8859-1?Q?ce/CK2OeT858GrSZp6aK7qIEzzBbFKfjfy6Pd5JSCFHNN207DZ1KANnm8g?=
 =?iso-8859-1?Q?BSW1MInGA1T9WmfY3x5LbEwwgGOmkdT8W3ZH1B7pY7Fi25qCLggDhZbBnu?=
 =?iso-8859-1?Q?iQTOl6uBGcRdq9iJIvkxFVvuhE1NptGxLsIbUlkaAF0rXoqxD8IhmFcCiT?=
 =?iso-8859-1?Q?DscuizNB0QW3VZ6gKcqCR3d6qRDnnlqWK94aKyV9D8IXcRUILrxClvAGEQ?=
 =?iso-8859-1?Q?I11QtnDmZZzFKJFKq0P0KZnRjq+9MwZYXl0CW3KLW9pSKN1DRV/39X7POQ?=
 =?iso-8859-1?Q?nfSW93c1hU+oQnCNt/pFa7kC2sB/xTLXGVDysmMrxhlNX8u1GS7JKesZd3?=
 =?iso-8859-1?Q?FYtIf9hiRWkclQyr2xvnFzYiwsfL1NHyfQjyuOTf8FQWl3ntvW4xTv15jg?=
 =?iso-8859-1?Q?KqWJCp6TaAMhJZk7k7WUusI0ZqMtMYsm1YXfKVPsMaMuebzSEwqeeaREPk?=
 =?iso-8859-1?Q?AXdfe24bAxCvsX4WtZ3kY63aBq49EWB/BMa4IW9/a+PCpTHdAMjFri/kGH?=
 =?iso-8859-1?Q?Rn1mFG0Hk0/hHQjDLpWcYXQqg6FFcHvrlrPA5e+Qp0sGVSXFc2eGZJr8as?=
 =?iso-8859-1?Q?2uf9d4Cekc85xnkjYKE998eRqp1z2ZpRedJjOBNlNhe8A42nZn3DMKDIMu?=
 =?iso-8859-1?Q?rNrrkpuV2z1jUr9KkqL1VFTBnjrjPEmh/cT5Rrs61XGXbqBKFE5rnAeHZY?=
 =?iso-8859-1?Q?Cqxm36LhUwdUD+qrK8B214Rvk9GVUfAWsUflKYnJdejeHMnDXEcyXEn1eJ?=
 =?iso-8859-1?Q?SAG6vWNcwvdn90Nyulo9UF23gWCvvGOkLyCghCTuvVcVKeKs3Sj/qQaA?=
 =?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: 
 a4121f6e-b210-4236-ee5b-08dc92036094
X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Jun 2024 15:03:58.2159
 (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: 
 ulHfAAhxrWeaPXr8aA9/xI8EhO6At02qdKJfDKdV9SV2hEC4zdSLJXb3sBJI0BPOSWHw4bkojzkwWP5yoebk/dKsQiai2fq43devXxasazU=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN4PR16MB4862
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: 
 <https://www.postgresql.org/message-id/LV3PR16MB6001FF31889B0B0DD4EF6476E6C92%40LV3PR16MB6001.namprd16.prod.outlook.com>
Precedence: bulk

On=A0Friday, June 21, 2024 10:48 AM=A0David G. Johnston <david.g.johnston@g=
mail.com>wrote:=0A=
=0A=
>Yes, but the bug is yours.=A0 The definition you want is:=A0 RETURNS SETOF=
 physical_table (not tested though)=0A=
>What you did was produce a one-column table whose column type is a composi=
te (and whose name is like - what with case-folding of unquoted identifiers=
).=A0 Since that table doesn't exist anywhere in the catalogs it has no Tab=
leOID.=0A=
=0A=
SETOF also does not return correct RowDescription data. Table OID and colum=
n number are still both 0.=0A=
Both versions have the exact same pg_proc.prorettype. If I join this onto p=
g_type, the pg_type.typrelid =3D 'physical_table'::regclass.=0A=
=0A=
Regards,=0A=
Maxwell=