Re: Unused system table columns

Tom Lane wrote:
> Rod Taylor <rbt(at)zort(dot)ca> writes:
> > For all intent and purpose, pg_index.indisprimary can be added to that
> > list. Can't make a primary key without a pg_constraint entry.
>
> I disagree. For one thing, there are clients that look at that column.
> There's no percentage in breaking them to gain zero (and it will be
> zero, because of alignment considerations...)

Yes, pgaccess uses it, as I remember. Would be nice if it was accurate.

>
> indisclustered is currently pretty useless, but may become less so
> if CLUSTER gets upgraded to usefulness, so I'm not in favor of deleting
> that either.

Yea, I can see that being useful some day.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026