Re: invalid non-zero objectSubId for object class

[Michel Pelletier <pelletier.michel@xxxxxxxxx>]

On Thu, Jul 9, 2020 at 5:26 PM Alvaro Herrera <alvherre@xxxxxxxxxxxxxxx> 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 = "" 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