Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 22FDA632D86 for ; Sat, 7 Feb 2009 13:05:38 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 72483-07 for ; Sat, 7 Feb 2009 13:05:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 592AD6323FA for ; Sat, 7 Feb 2009 13:05:35 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id n17H5XS17017; Sat, 7 Feb 2009 12:05:33 -0500 (EST) From: Bruce Momjian Message-Id: <200902071705.n17H5XS17017@momjian.us> Subject: Re: Clarification to catalog-pg-class In-Reply-To: <4980AF83.50707@agliodbs.com> To: Josh Berkus Date: Sat, 7 Feb 2009 12:05:33 -0500 (EST) CC: pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/1 X-Sequence-Number: 5047 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 http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +