RowDescription for a function does not include table OID

2024-06-21 Thread Maxwell Dreytser
Hello, I am working on a meta-programming use-case where I need to scrape some detailed information about the results of a function that "RETURNS TABLE (LIKE physical_table)", which ends up with prorettype = 'physical_table'::regtype. The problem is that for the query "SELECT * FROM my_function(

Re: RowDescription for a function does not include table OID

2024-06-21 Thread Maxwell Dreytser
On Friday, June 21, 2024 10:48 AM David G. Johnston wrote: >Yes, but the bug is yours.  The definition you want is:  RETURNS SETOF >physical_table (not tested though) >What you did was produce a one-column table whose column type is a composite >(and whose name is like - what with case-folding

Re: RowDescription for a function does not include table OID

2024-06-21 Thread Maxwell Dreytser
On Friday, June 21, 2024 11:28 AM David G. Johnston wrote: > Interesting, then I suppose it is semantics.  There is no table involved - > you are referencing the type of that name, not the table - so no TableOID.  > There is no guarantee the row you are holding came from a table - and I'd > i