Re: invalid non-zero objectSubId for object class

On Thu, Jul 9, 2020 at 5:26 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)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
>