Re: BUG #4238: pg_class.relhasindex not updated by vacuum - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #4238: pg_class.relhasindex not updated by vacuum
Date
Msg-id 20080613165645.GQ5534@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #4238: pg_class.relhasindex not updated by vacuum  ("Lawrence Cohan" <lawrencec@1shoppingcart.com>)
Responses Re: BUG #4238: pg_class.relhasindex not updated by vacuum
Re: BUG #4238: pg_class.relhasindex not updated by vacuum
List pgsql-bugs
Lawrence Cohan wrote:
> Isn't a PK a CONSTRAINT and not an INDEX???

Sure, from a logical point of view.  The implementation of that
constraint is an index.

> In that case the two separate pg_class relhasindex and relhaspkey would
> make sense indeed - just a thought nothing else and we'll take it as is.

What would be the point?  If you want to figure out whether a table has
a primary key, you can query the catalogs.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-bugs by date:

Previous
From: "Lawrence Cohan"
Date:
Subject: Re: BUG #4238: pg_class.relhasindex not updated by vacuum
Next
From: Tom Lane
Date:
Subject: Re: BUG #4238: pg_class.relhasindex not updated by vacuum