Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id A0CB7632FED for ; Wed, 11 Feb 2009 23:17:17 -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 03937-05 for ; Wed, 11 Feb 2009 23:17:13 -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 1CA31632FE0 for ; Wed, 11 Feb 2009 23:17:13 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id n1C3HCO16080; Wed, 11 Feb 2009 22:17:12 -0500 (EST) From: Bruce Momjian Message-Id: <200902120317.n1C3HCO16080@momjian.us> Subject: Re: Clarification to catalog-pg-class In-Reply-To: <49929912.9070803@gmx.net> To: Peter Eisentraut Date: Wed, 11 Feb 2009 22:17:12 -0500 (EST) CC: Josh Berkus , 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/9 X-Sequence-Number: 5055 Peter Eisentraut wrote: > Bruce Momjian wrote: > > Josh Berkus wrote: > >> Bruce, > >> > >>>> 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? > >> Because I've encountered two people on IRC (and a client) who were > >> confused about this, and it confused me briefly when I fielded their > >> questions. Saying "CHECK constraints" would also probably do it, or > >> saying "check constraints (only)" > > > > Uppercase done, with tag. > > This is inconsistent with the rest of the documentation. Should I use ? ? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. +