Re: invalid non-zero objectSubId for object class

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?


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