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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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