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+4AACvcAgAAAy4U=
Date: Fri, 21 Jun 2024 15:41:09 +0000
Message-ID: 
 <LV3PR16MB60016206D56BF62B51D0568BE6C92@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>
 <LV3PR16MB6001FF31889B0B0DD4EF6476E6C92@LV3PR16MB6001.namprd16.prod.outlook.com>
 <CAKFQuwbSJ3Muor4MELvASxmSa4JUhXjduaas1tMrpDKj1=QPGw@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwbSJ3Muor4MELvASxmSa4JUhXjduaas1tMrpDKj1=QPGw@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_|LV3PR16MB6068:EE_
x-ms-office365-filtering-correlation-id: 563d34bf-42c0-49e3-db43-08dc92089246
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230037|1800799021|376011|366013|38070700015;
x-microsoft-antispam-message-info: 
 =?iso-8859-1?Q?5Duzf5jXfRAp002zWqx7i3VSm7X/kl+NGMZKaKEEZIlEJ31vhBhjrFrhQH?=
 =?iso-8859-1?Q?J+a22Q1jrabdF2371SqctauZgni66NVF3ySYp58ecD5mxy5IHhexImMZHD?=
 =?iso-8859-1?Q?jcgw7WljUu6gqevhkwfGL3uD/exMeeBYmqZzr1WhplK/rh57XZSLn5OjcL?=
 =?iso-8859-1?Q?7wJZjeR1AHZvbA0LnqPne+UqFLaFPC3jTstjxKBXuUb6TdWlMrK/oeqYpg?=
 =?iso-8859-1?Q?alSjaScFp/KgXV4f2FAseZAh/PsRqlSWRMAHULhuNRMbJzpoKP+blGoeJG?=
 =?iso-8859-1?Q?8SDgEb6q1P/C00Zc4fMo9tR7kM0JZRJQqMrZ6vyMUGhcXmqEm9tIjrdyEg?=
 =?iso-8859-1?Q?MZB87P8bnPGLamLTl1Hfpr/fOlRsDHEFOwyIYttAGfmLjYlAz26Rg2JMYi?=
 =?iso-8859-1?Q?376fhrybaCr+PjeYwQW7ZN8nNc/CDAG2JSsuh9D4Q3nMDetzuzIti/NCK8?=
 =?iso-8859-1?Q?p8tkNNhbxP8D6PTpX7hMaMlfflQPQ7LYlCfGOfYepMK179aUthzep0uhPS?=
 =?iso-8859-1?Q?meUfaTT7vAlx/ZJ8inEk6MCFXGKm+i9HiSL6GrUbqPoryqZqlL5z4HEZpr?=
 =?iso-8859-1?Q?ev8tPNNR84MIWeSo75efEqVljDIuhPpUMUS6XMCSolcHqpQSRyYF6BYG1Z?=
 =?iso-8859-1?Q?tIY2O4ei8XcDTX6GT0UWeIMIzfWvBiy1JkWSFT+PwnfKBdBPLQB82xOeoZ?=
 =?iso-8859-1?Q?i683DP8zLRmzttul4LhTAXfOwQKh2v+fS8fArQrG/CL6ddcgL7almwReI8?=
 =?iso-8859-1?Q?22s05CxtiuOl56Mf//qr6IWMz8fl4vu0/s+h7CWtzPDgRebzdsLRctynee?=
 =?iso-8859-1?Q?TRpPSMAwPqdjpwdpj9T6vbbURhswVW7eSg77Pw+I1ve0IEebfCD5ikOGcs?=
 =?iso-8859-1?Q?CbldPlGXfUjEJzsQdNdat3mnR0G/oqVC4ufF7z/IG2gmseYUTVfdl6r8EZ?=
 =?iso-8859-1?Q?PGgzW54E0dHeyfAshtXm8g2V89WMp92a1Qax0cUMNICHdMdUxsB5Oq9YYV?=
 =?iso-8859-1?Q?2KOumDLmLDFR7Hh7ce1zFb1QyMvMItNdc/AxiAYmIdmWuhsO/J/lagrFVW?=
 =?iso-8859-1?Q?dxFpMAhPhjtxgTCQUkMlVGqQFAtogBlReUSRALa0DMMCCm7eM9PjJog0du?=
 =?iso-8859-1?Q?4Pda6gqYrSf0eTplmuykwTHTGgq0aWDrNaIksU7Jx/zOX1nqtZFO1u17zc?=
 =?iso-8859-1?Q?XpmEROn+6RKvnCK7k2sE2SuZiK+v4VmllvTUGEyatYQ33FVWLj6AcUWePV?=
 =?iso-8859-1?Q?MmQ3z6IQyVKobMnV3hCUnobJGOzN0zAsbmSLo2Qz+DudSOPJTWDnmKUBAl?=
 =?iso-8859-1?Q?6SozbtEcbUGHd9ZBSNwd3XRYA6ttkXpYx/YxXBrsVfr9L4Y0UmK3KO96HM?=
 =?iso-8859-1?Q?GTTuEx2xFw6gudE6YXPUy1aHJ3DZop0VYwry578Ch9mP7qhoQkbfM=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)(376011)(366013)(38070700015);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?qaFhm9uFWXWL3eMUU/C7AzFZjdVMtwhFymojgXyKR3PR9R3mL1F9zlIY8j?=
 =?iso-8859-1?Q?YU8gLGviag3BXULCaloZ6D0Jejdboqu1eGlcjoAcdBBFsfdfis43/LE26K?=
 =?iso-8859-1?Q?xaKsprg+xpTMYHNeHM1juphnVmJK0I0U9WFwo9voBgEjkOfxBLS9U1jeau?=
 =?iso-8859-1?Q?lMSXNtB568jngo+1uZ7a8OdW0DzCEtikhVzyxknyySqb5nZ5o0epdcHEjA?=
 =?iso-8859-1?Q?Cuu/+qajUMBNnvfTDnM7LIIgyoxnORdUzIQoCS8nUiJPOB5tQq4G3JaJvu?=
 =?iso-8859-1?Q?1xUc23w0NwhE26xrTNdW3LQ7BD7YvMTQjnTi9V4J6+xXl+5wePloPIAQzp?=
 =?iso-8859-1?Q?S4I98Aijz5SrH073UH40Ry8le4zjFK5bIFMa004QAAgp6TYDKjh0j/ot/+?=
 =?iso-8859-1?Q?4jRmYpY/huBbB8vFqweMO0HbReqj5KmI/GtZhYN8sQImVNNB1vOlX1srYq?=
 =?iso-8859-1?Q?9mFT+FQgNv85TxOMydL5HKFY1lSZARHjZpGV/pe5vi+maI9fJRQJNF8Nbt?=
 =?iso-8859-1?Q?0ly7xEKBt4E3L4q2dFVBgU3MmZ4akJrGGTORcwCLsuIAMtdyY8Lxi9293l?=
 =?iso-8859-1?Q?BVorLqAClK7oBFhhs8rjJLGnWlIkHr8+MVM7MTSMssd8Toxboyp5xJzvWK?=
 =?iso-8859-1?Q?MHQ494lNhm+kg1ky4Q5R5RjgE57WZwA8uqxKKNX/5Hvfga8iStL5HS68r8?=
 =?iso-8859-1?Q?szEBnbnGPuKo9KJEGlPsDvfWbDN3Cg+HLPplsNH66kuAxtP0URsyRN7454?=
 =?iso-8859-1?Q?cbrIpsr8OFLdrbkalIJfIF/WXzage8gF8CMLqytZaQtNZQsdmXTLDdqfLW?=
 =?iso-8859-1?Q?1oRco/nnRd9Uo99vRg02Fz9VaJjHKp4nvxMxUpDsXpnpzIw+1cCh4BrWRN?=
 =?iso-8859-1?Q?CbfRH3z+dj4kNNrlIVZdjGrEYKzuO76klVPS9JICqF5TFx5ZjNdTCphPzc?=
 =?iso-8859-1?Q?uleVmsG/WfWEbNRKDWCwc+Hq6OVwoLwhQ4qFoQ6Sa+0OVfKY1ZDbJZHsNY?=
 =?iso-8859-1?Q?YfIOKU94JF0jH8w34/73ZXPoXXfUYMVIdiO5DcJwSBb+KFq+nKpSa7STLl?=
 =?iso-8859-1?Q?hDWBUHexxmgOETzaSsgj7t91gbzF+AuRoUyr4RbYfOt8E/k6o4qN37kB6D?=
 =?iso-8859-1?Q?DfvBJFhbT6F0U5ObGcH01EcQzTKCuLS3D9sKl/XTf81GXzGbv/f8G6onzs?=
 =?iso-8859-1?Q?bvBYzoswg9KTzgEGmecJTS+wqvQUFzlgh/lyUPqeaWfFWmKajFB58oq4QC?=
 =?iso-8859-1?Q?Ckt59DqKLbQE8DScsI0anncjxEt/Bt+k6/oo8btDpkulObGGHoSz9v+KWl?=
 =?iso-8859-1?Q?KLndnjEsnQ5BYrR8OfniartLww+k9JRpAKkJJ268GKeKukxrMa3cWoFSZb?=
 =?iso-8859-1?Q?lkiPkC4+CsNUWaQDfFqxXMFinTQ3jkSZul1cBsm8MQrkRxHiAhSd68AiMg?=
 =?iso-8859-1?Q?RQ7hkNpPkTwD2DLaAIUPmQghkmkWcCnFpamZbDXt0/ucWO/p6efV52HZTA?=
 =?iso-8859-1?Q?02rks0ajbmY7IDcOVrZGqVJ1sjLIEDALlbjLMXqrf4KwLZO/vmjzciespk?=
 =?iso-8859-1?Q?Q4n5dDcQ80bkkZi19wu3epeeDrDn8FaHII+D/uudoMu13YO007jApIIqXa?=
 =?iso-8859-1?Q?ppb/E45MUHUg7vNn47Gg8EvlsIvFBQYVF42xWrdIQFEHQq9JWhMP77nw?=
 =?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: 
 563d34bf-42c0-49e3-db43-08dc92089246
X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Jun 2024 15:41:09.0894
 (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: 
 Gvh79B+EMjChl9yaM5GNXQ32MDMI+1zANoaLkyohEqt4kSOcmhzy2jHuCNEDasCwDO9hNCnHO8yDI8SaN2mrX0aWCGkwjW7YVHpb2pKp9PY=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: LV3PR16MB6068
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/LV3PR16MB60016206D56BF62B51D0568BE6C92%40LV3PR16MB6001.namprd16.prod.outlook.com>
Precedence: bulk

On Friday, June 21, 2024 11:28 AM David G. Johnston <david.g.johnston@gmail=
.com> wrote:=0A=
=0A=
> Interesting, then I suppose it is semantics.=A0 There is no table involve=
d - you are referencing the type of that name, not the table - so no TableO=
ID.=A0 There is no guarantee the row you are holding came from a table - an=
d I'd interpret the current behavior as conveying that fact.=A0 Though the =
current wording: "If the field can be identified as a column of a specific =
table, the object ID of the table; otherwise zero."; and the observation th=
at at least a human "can identify" a related column, leads one to reasonabl=
y infer the system should be able to make such an identification as well.=
=0A=
=0A=
This is exactly my point. If the return type of the function is strongly li=
nked (directly in the function schema) to the table according to pg_catalog=
, the field can obviously be tied to a specific column of that specific tab=
le. The RowDescription not having that value filled in is a violation of th=
at promise.=0A=
=0A=
> In short, the system doesn't generate the information you need, where you=
 need it, to tie these pieces together.=A0 Modifying existing elements of t=
he backend protocol is not presently in the cards.=0A=
=0A=