Re: invalid non-zero objectSubId for object class - Mailing list pgsql-general

From Michel Pelletier
Subject Re: invalid non-zero objectSubId for object class
Date
Msg-id CACxu=vJtFKj3fwBtDDnGm9V0AGXMvf837b_nO0-Oxdp=dMiGcQ@mail.gmail.com
Whole thread Raw
In response to Re: invalid non-zero objectSubId for object class  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general


On Thu, Jul 9, 2020 at 5:26 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
On 2020-Jul-09, Michel Pelletier wrote:

> Hi Tom, thanks for getting back so quick:
>
> I don't seem to have either:
>
> dev=> select * from pg_depend where classid = 297108 or refclassid = 297108;
>  classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype
> ---------+-------+----------+------------+----------+-------------+---------
> (0 rows)

Maybe try looking in pg_shdepend?  Or pg_description?

Hi Álvaro,

It doesn't occur in either of those either
dev=> select * from pg_description \g | grep 297108
dev=> select * from pg_shdepend \g | grep 297108

-Michel
 


--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: invalid non-zero objectSubId for object class
Next
From: Michel Pelletier
Date:
Subject: Re: invalid non-zero objectSubId for object class