Date: Fri, 2 Dec 2022 23:14:05 +0100 (CET)
From: Erik Wienhold <ewie@ewie.name>
To: Jonathan Lemig <jtlemig@gmail.com>,
	"David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Message-ID: <1540400959.42131.1670019245837@office.mailbox.org>
In-Reply-To: 
 <CABR8q_-7hBs8O=JBeTXN20+g9Q3M4WNv80csa9Ah3HMpB2_0gA@mail.gmail.com>
References: 
 <CABR8q__QVKFzaUdQQsyU2wd2TZX1tdv7Q8M5myQ8L=BDDAtjLQ@mail.gmail.com>
 <CAKFQuwb3xQ5UbyFqW3TFDKBenBrngUXrA4152-3yT8Aeb1eSYQ@mail.gmail.com>
 <CABR8q_-7hBs8O=JBeTXN20+g9Q3M4WNv80csa9Ah3HMpB2_0gA@mail.gmail.com>
Subject: Re: Views "missing" from information_schema.view_table_usage
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Importance: Normal
Archived-At: 
 <https://www.postgresql.org/message-id/1540400959.42131.1670019245837%40office.mailbox.org>
Precedence: bulk

> On 02/12/2022 22:55 CET Jonathan Lemig <jtlemig@gmail.com> wrote:
>
> drps=3D> select viewowner, schemaname, viewname from pg_views where viewn=
ame =3D 'platform_version_v';
> =C2=A0viewowner | schemaname | viewname
> -----------+------------+--------------------
> =C2=A0drps | event | platform_version_v
> (1 row)
>
> drps=3D> select * from information_schema.view_table_usage where view_nam=
e =3D 'platform_version_v';
> =C2=A0view_catalog | view_schema | view_name | table_catalog | table_sche=
ma | table_name
> --------------+-------------+-----------+---------------+--------------+-=
-----------
> (0 rows)
>
> The event.platform_version_v doesn't show up when querying the view_table=
_usage view.

Does platform_version_v reference any tables?  That view name suggests that=
 it
provides some version info, e.g. with a definition like:

    create view event.platform_version_v as select '1.0.0' as version;

In that case it won't appear in view_table_usage.

--
Erik