Re: Views "missing" from information_schema.view_table_usage - Mailing list pgsql-general

From David G. Johnston
Subject Re: Views "missing" from information_schema.view_table_usage
Date
Msg-id CAKFQuwb3xQ5UbyFqW3TFDKBenBrngUXrA4152-3yT8Aeb1eSYQ@mail.gmail.com
Whole thread Raw
In response to Views "missing" from information_schema.view_table_usage  (Jonathan Lemig <jtlemig@gmail.com>)
Responses Re: Views "missing" from information_schema.view_table_usage
List pgsql-general
On Fri, Dec 2, 2022 at 1:52 PM Jonathan Lemig <jtlemig@gmail.com> wrote:
Has anybody ever encountered this, and if so, did you find a resolution?  Or perhaps there other limitations with the VTU that I'm unaware of?


Well, the query itself is available in the source code if you want to experiment on your own.  Otherwise, I suggest you produce a self-contained example that fails to produce one or more rows in view_table_usage that you believe should be present.  Whether it is a bug report or trying to point out what you are misunderstanding, diagnosing this situation with the information you've provided is not a productive activity.

David J.

pgsql-general by date:

Previous
From: Jonathan Lemig
Date:
Subject: Views "missing" from information_schema.view_table_usage
Next
From: Pasi Oja-Nisula
Date:
Subject: Re: Stored procedure code no longer stored in v14 and v15, changed behaviour