On Friday, June 21, 2024 11:28 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
> Interesting, then I suppose it is semantics. There is no table involved - you are referencing the type of that name,
notthe table - so no TableOID. There is no guarantee the row you are holding came from a table - and I'd interpret the
currentbehavior as conveying that fact. Though the current wording: "If the field can be identified as a column of a
specifictable, the object ID of the table; otherwise zero."; and the observation that at least a human "can identify" a
relatedcolumn, leads one to reasonably infer the system should be able to make such an identification as well.
This is exactly my point. If the return type of the function is strongly linked (directly in the function schema) to
thetable according to pg_catalog, the field can obviously be tied to a specific column of that specific table. The
RowDescriptionnot having that value filled in is a violation of that promise.
> In short, the system doesn't generate the information you need, where you need it, to tie these pieces together.
Modifyingexisting elements of the backend protocol is not presently in the cards.
From my perspective this is clearly a bug as there is no way to define a function in a way that provides enough data to
thereader.
Regards,
Maxwell.