Horton

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

Chris Bitmead <chris@bitmead.com>

View thread
From: Chris <chris@bitmead.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgreSQL.org, pgsql-sql@postgreSQL.org
Date: 2000-02-03T13:05:32Z
Lists: pgsql-hackers 
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.