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.