Re: Clarification to catalog-pg-class

Josh Berkus wrote:
> All,
>
> Currently, catalog-pg-class is a bit confusing as to where FKs are
> tracked in pg_class. Please update the lines for relchecks and
> reltriggers to read:
>
> relchecks int2 Number of check constraints on the table (but not
> other types of constraints); see pg_constraint catalog

Uh, why do we have to say "but" when we clearly say "check constraints"?
Do we need to say "CHECK" contraints?

> reltriggers int2 Number of triggers on the table, including
> constraint-triggers for foreign keys; see pg_trigger catalog

pg_class doesn't have that column anymore, it has relhastriggers.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +