public inbox for [email protected]  

help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: Maxwell Dreytser <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: RowDescription for a function does not include table OID
Date: Fri, 21 Jun 2024 08:52:00 -0700
Message-ID: <CAKFQuwaoF+3VTmrxZ+xwifS6sSHbSpdLuSv2w=rRxiopWJUa_w@mail.gmail.com> (raw)
In-Reply-To: <LV3PR16MB60016206D56BF62B51D0568BE6C92@LV3PR16MB6001.namprd16.prod.outlook.com>
References: <LV3PR16MB6001AF4D05893E9FF4B3C746E6CE2@LV3PR16MB6001.namprd16.prod.outlook.com>
	<[email protected]>
	<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>
	<LV3PR16MB60016206D56BF62B51D0568BE6C92@LV3PR16MB6001.namprd16.prod.outlook.com>

On Fri, Jun 21, 2024 at 8:41 AM Maxwell Dreytser <
[email protected]> wrote:

> On Friday, June 21, 2024 11:28 AM David G. Johnston <
> [email protected]> wrote:
>
> > In short, the system doesn't generate the information you need, where
> you need it, to tie these pieces together.  Modifying existing 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 the reader.
>

Quick search turned up this prior thread:

https://www.postgresql.org/message-id/19323.1245720832%40sss.pgh.pa.us

Based upon that unargued point the only bug here is in the documentation,
leaving the reader to assume that some effort will be made to chain
together a function returns clause to a physical table through that table's
automatically-generated composite type.  We don't and never will modify the
existing protocol message semantics in that respect.

David J.


view thread (14+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: RowDescription for a function does not include table OID
  In-Reply-To: <CAKFQuwaoF+3VTmrxZ+xwifS6sSHbSpdLuSv2w=rRxiopWJUa_w@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox