From: Maxwell Dreytser <Maxwell.Dreytser@assistek.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
CC: "pgsql-interfaces@lists.postgresql.org"
	<pgsql-interfaces@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/qTIeG1LHM4zoAgAAAzMs=
Date: Tue, 18 Jun 2024 04:28:34 +0000
Message-ID: 
 <LV3PR16MB6001CD31C5982777BA9BA25EE6CE2@LV3PR16MB6001.namprd16.prod.outlook.com>
References: 
 <LV3PR16MB6001AF4D05893E9FF4B3C746E6CE2@LV3PR16MB6001.namprd16.prod.outlook.com>
 <3528232.1718682678@sss.pgh.pa.us>
In-Reply-To: <3528232.1718682678@sss.pgh.pa.us>
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_|SA1PR16MB5102:EE_
x-ms-office365-filtering-correlation-id: f5f6294b-bcf8-4e56-b6f0-08dc8f4f1df5
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?fy8ZIKNnJlS22LDxm2bDz1X58k8Wu+TFBzF3nqt9rIcx3UiKjbP1xmECPx?=
 =?iso-8859-1?Q?nuFlOuscXO1QYfPYX3Cs0TW7SzJNpU61zLUEinoPPnwsLjZY3c1jXpZoJg?=
 =?iso-8859-1?Q?CEaKfK0jHcKCRaqOzw+C+TXkpySaj6a4t1rMDphnjY8MK+GSUZRAKznUE9?=
 =?iso-8859-1?Q?tKWMb83A0moOlovq8L/ZPCKeA8R0/gZFIvZfUpvFRH4HMJy5VBrDKVlex0?=
 =?iso-8859-1?Q?5dbc8yK+XDHxfhl5XuTeHNZwkYefcOisIj1Vf0sg0Ba97Q9kbyzDl5gu17?=
 =?iso-8859-1?Q?ZPsBuk9g1ZJWryRSp+3O/I0K+JJu0iECiL8hZUxGtO//2NGEQoNbLeyyR7?=
 =?iso-8859-1?Q?n5SzCqR9lJYt01BfwYkdzfnqlS/e24B/1yNOIg5OHfWZ8nO8MEf3iVk9g6?=
 =?iso-8859-1?Q?QrA+U3w8hQ556au+73gX/v7w2bB3OoEDJb1L0b6NlqjTB73oI2FFOQQJJV?=
 =?iso-8859-1?Q?RTZoBIAYYsMMecGnEs2l6pygjMu3SniSCfszpYbzhCpAI5KScY2XyFZHKF?=
 =?iso-8859-1?Q?jCR2/sbfw7aE+e6JPZWpVJVBjc1j2NGG6WiM/y+fMBOVgy9XkMuc+T97BK?=
 =?iso-8859-1?Q?UuXBYjWdJjKu7rNtdy7sJDhjeRQt7ck17YosV/NhTT98Kql102MwW2fFEw?=
 =?iso-8859-1?Q?IdougqiGwhV/R70vdeZWs8l/uZUOSyPuzYRxLLBqi11LktJ00ihrK0rA63?=
 =?iso-8859-1?Q?nmwV9fpqUjxivgMHgORLC4igWhgVJlnQDgulN04xeLVRPDc99L0IqnbZmW?=
 =?iso-8859-1?Q?JfBB+//mzwtbtILC59BkHnUccDjT1YqmzJG+rcz4a49GzNQrDfC7EdVqBs?=
 =?iso-8859-1?Q?8duXPjHeXqEJWsNFzC21+v09EubK/iYvr1QR0TNg6pYJ7ZzFeoA+AWZzg9?=
 =?iso-8859-1?Q?MKMngSztoFMIq6slJC6Ahkyyhoxld35BCkiEJkvGWKfMsl1ErY+yNwLLDf?=
 =?iso-8859-1?Q?2ooxnX20+aiIKM9SSvvPEph+qkHcwsAT6R6V9yUrhj+AO2JG2z0sCtfjZv?=
 =?iso-8859-1?Q?QfMOjrGLakdmX5f+/MJuh8MPKQh7WAgMgRo/a+3sCs15GI42mHyDRV0FGE?=
 =?iso-8859-1?Q?gZ0fSiDF2DGMzlZoFjveI5F8Oudm1c7lgmf2TvrDxQdIeu/SZZYFieC/ci?=
 =?iso-8859-1?Q?mxGhtY+/PCEa1V0Q4LcEgwk4Upp46p2uyQn4p+vDo2KFCzlMawQFLsY6mW?=
 =?iso-8859-1?Q?7fHbnJON20MzqERJMPj0jILj2Z9eQLi3RQVP+DQRFG9OIMd0kZFvthHGoK?=
 =?iso-8859-1?Q?ZPU2QDPCpOFDO8o4ODYSBCBsJn4m60UWUCtL7ohhGRsuofvBbPEamObR5t?=
 =?iso-8859-1?Q?cycUEJq/TxcYKs42EnHmXwl52rNPGQvIMKJplTxTy1Ds6aIK9MPM5nrDJ6?=
 =?iso-8859-1?Q?/u52UFkefd44TkyV99bjSWRxDM6qByre6DPBLL9KnN2yA0HsjFuF8=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?kCJRmaD30Iohn6jjLYJbEuks1U/vH13Bxq5R4Q4HpSTq2a8HNS5mozoI+h?=
 =?iso-8859-1?Q?HqTY0M34pVu+mMgFxHqxo9EOteQOv6WcJAgFPg0zvPxCzhNS3vPlvrEmsL?=
 =?iso-8859-1?Q?BYbQcIkgu6kxcuX53QRq6mo2gegvFfLN8D41I4pG9kQ/rjPzcaHu89v1Qk?=
 =?iso-8859-1?Q?rpfyS5DZELReR/t6LcMionljTPTt6DsrwqtPbu0PWGhptMVPxmD/cXPgUk?=
 =?iso-8859-1?Q?az5SdoCAJy115i4lML4i4XkRweAZ68GMbLnJp0R4QR7Yz/uv1ZdJLrKDmt?=
 =?iso-8859-1?Q?VDMXq5TBAqr0qdRO5A1dEmRajyUIw/gshe3DwIGjWBfUeetKM7FpictKEK?=
 =?iso-8859-1?Q?We4oA/hOUmcXnJeYPYmFeaN6xQFZVHXyfB3vKZ+oYxFvR4pcvu5W3AW5WX?=
 =?iso-8859-1?Q?pvluUH/E4l2n6OPN4GhNLvJ8TaAFI9H3YwmOJ1rrghhbEP96hYHsBgThoX?=
 =?iso-8859-1?Q?O3kOFp26ypH3jnaPHEaMRUDHXTRjizXQFzzffjAOzgwY9VChy/JIXZV9QT?=
 =?iso-8859-1?Q?eHZOVKVgpq0apdMhEJusGh5Gql3Bf5+Xt4aO+NL7mYBrUz4ZTX+oCyRo1S?=
 =?iso-8859-1?Q?s4e03tzW9JuZHs+kD9kgUfIgpowLJnV1eHFvmNxgb5hTRHuVk+EvjViW+t?=
 =?iso-8859-1?Q?+VDh+MI8IWtk8cdr2UArBud4k9c4SxZaLRt2u7Q7cInEG9n2rTBFeVnt/f?=
 =?iso-8859-1?Q?bVjd37nreiZCm6vJf+f+xBDF9PF5N/NiHNQ4IJuI50HzdfrRmjPeBYjTX4?=
 =?iso-8859-1?Q?Aa443BdO7c/EyTQqx1bpTlvFnZVGqX+OtzJU3+ZSX3zApjHQnBMjzFmS3g?=
 =?iso-8859-1?Q?r0V/wBMl+/NhzdbjOaNVu9DNSqijlGqGQN4od5SLbMvd/cAH2YpQ2fpR99?=
 =?iso-8859-1?Q?AdqbzG8buLt4gLOGw/1/w3o5+vJx/gyhHaygwhQWXqlovq46BVGDdc0LBE?=
 =?iso-8859-1?Q?qG4ME1uWwfnYGXQelIqtC2hc4u1onygpe5ZDgAB6eQxEPwX8zev3UQq87L?=
 =?iso-8859-1?Q?0WeW695uJrOIdAlYfysPotVgBlEREJi42lclYGpoF6n6d5PMZZELzgQxO9?=
 =?iso-8859-1?Q?i0BOlOliAo6MJezEbNHSubGPgHlJ5W5RFzprSWS2ob2shLgrHncGRimPnA?=
 =?iso-8859-1?Q?eiqjrA8/GVT6w0nx2/F99E//rHQA/Y9DIoitjpYEoqrwPwMfkxZrqCjj+i?=
 =?iso-8859-1?Q?fV8IZ84hBMDjFWW8AC6ySxZzFe9RxPD/XALBo1F/PgpoN5Z/lDpNPKGojf?=
 =?iso-8859-1?Q?6Bwd8fncFDC36PXmeyWmKOGhrMEpRtrO24y9icDFmk3MQjCM9Bh87j3iYN?=
 =?iso-8859-1?Q?nH1mSnogboFKlPV33zJhTldjPd7hLEJaKCDMPoCDLBnJ8sPtemqFgdvUNQ?=
 =?iso-8859-1?Q?UsvMVvya1Z3po1V+vSfOWkLfDf7NuyuqNpWqZBCX3vPd92X8d2CpFvzItc?=
 =?iso-8859-1?Q?af99Intp5ZDrtkTdFpaJm8hnUsJ9kjPG8C5k4VoIGDagV7yLOEM0NM9lmk?=
 =?iso-8859-1?Q?YZHFZV4yqRJPNvuzMSLKZZoo/hzEbys8BFg33fOdlNRhUXavHnoqrrbRZR?=
 =?iso-8859-1?Q?EdiTc0RarpxrfJYmxjSD7Zzat3ubNgKNBzI+ebHwFXz+XYb2RLTzQUEZSH?=
 =?iso-8859-1?Q?jSNUBUg7uVBUpkaEwFIDV/SuF4Lvl9HHTp5K0l/cs+dEp9lOpM8V2qPg?=
 =?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: 
 f5f6294b-bcf8-4e56-b6f0-08dc8f4f1df5
X-MS-Exchange-CrossTenant-originalarrivaltime: 18 Jun 2024 04:28:34.6976
 (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: 
 w+9izp90vUYvzplB49sQ+SnWmRBcP/oRqc5lQBwc9NIKuEPutvVc+l9Wmx82IUyZkogGExxQutv9aO56W05xX/+i6wDuWhzBNvluRJAGB7M=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA1PR16MB5102
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/LV3PR16MB6001CD31C5982777BA9BA25EE6CE2%40LV3PR16MB6001.namprd16.prod.outlook.com>
Precedence: bulk

From:=A0Tom Lane <tgl@sss.pgh.pa.us>:=0A=
=0A=
>Hmm, I do not think that syntax means what you think it means ;-).=0A=
=0A=
Its an interesting trick that I came across on DBA SE on a question named "=
How to use RETURNS TABLE with an existing table in PostgreSQL?".=0A=
=0A=
>However, it seems to end up with prorettype =3D=0A=
>physical_table'::regtype anyway thanks to some special rules about=0A=
>single-column output tables, so as far as I can see you should get=0A=
>the table's composite type OID as the column type OID in the result=0A=
>descriptor for "SELECT my_function(...)".=A0 Or is that not the case=0A=
>you're concerned about?=0A=
=0A=
The query I am running is "SELECT * FROM my_function()". According to Wires=
hark I can see that the returned RowDescription shows 0 for Table OID and C=
olumn index:=0A=
=0A=
PostgreSQL=0A=
    Type: Row description=0A=
    Length: 219=0A=
    Field count: 7=0A=
        Column name: table_id=0A=
            Table OID: 0=0A=
            Column index: 0=0A=
            Type OID: 20=0A=
            Column length: 8=0A=
            Type modifier: -1=0A=
            Format: Binary (1)=0A=
<snipped>=0A=
=0A=
>I'm confused about exactly what you're asking for, but (a) returning a=0A=
>type OID where a relation OID is expected is absolutely not OK ---=0A=
>there is no guarantee that those OID sets are distinct; (b) regardless=0A=
>of that, you seem to be asking for a silent semantic change in the=0A=
>wire protocol, which is going to be a very hard sell because it will=0A=
>probably break more applications than it makes happy.=A0 Why can't you=0A=
>get what you need from the composite type OID?=0A=
=0A=
I would indeed like the relation OID to be returned for the composite type =
that is returned from the function. Maybe this can be simply considered a b=
ug as it does seem like returning the relation OID that is clearly availabl=
e would be the expected behaviour.=0A=
=0A=
Regards,=0A=
Maxwell.=