Re: RowDescription for a function does not include table OID - Mailing list pgsql-general

From Tom Lane
Subject Re: RowDescription for a function does not include table OID
Date
Msg-id 600217.1718986666@sss.pgh.pa.us
Whole thread Raw
In response to Re: RowDescription for a function does not include table OID  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Fri, Jun 21, 2024 at 8:51 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> The PG wire protocol specification [1] defines these fields thus:
>>     If the field can be identified as a column of a specific
>>     table, the object ID of the table; otherwise zero.

> s/can be identified as/is/g  ?

> Experience shows people are inferring a lot from "can be identified" so we
> should remove it.  "is" maybe over-simplifies a bit but in the correct
> direction.

I dunno, that seems to me to be just as open to argument if not
more so.  Perhaps some phrasing like "can be directly identified"?

The real point IMV is that it's based purely on parse analysis,
without looking into the behavior of views or functions (which
could change between parsing and execution, anyway).

            regards, tom lane



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: RowDescription for a function does not include table OID
Next
From: Tom Lane
Date:
Subject: Re: Replication using mTLS issue