Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL

Bruce Momjian wrote:

> Oops:

>         test=> drop index i_test;
>         DROP
>         test=> select relhasindex from pg_class where relname = 'test';
>          relhasindex
>         -------------
>          t
>         (1 row)
> 
> Let me add that to the TODO list.

Why not change that to a relnumindexes as well? Easier to maintain and
more useful information.

> > >Could you do that for relhassubclass?
> >
> > If we made it relnumsubclasses and incremented/decremented on
> > CREATE/DROP, it seems easy in theory.
> 
> Yes, that would work.  Seems hasindex has problems.