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.