Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 97DD3632F76 for ; Wed, 11 Feb 2009 05:23:42 -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 64105-10 for ; Wed, 11 Feb 2009 05:23:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gattler.pezone.net (eisentraut.org [85.214.91.16]) by mail.postgresql.org (Postfix) with ESMTP id 7755A632CCE for ; Wed, 11 Feb 2009 05:23:35 -0400 (AST) Received: from dhcp-eesp05-101-155.Finland.Sun.COM (unknown [192.18.8.1]) by gattler.pezone.net (Postfix) with ESMTP id 9F22F1A28002; Wed, 11 Feb 2009 09:23:32 +0000 (UTC) Message-ID: <49929912.9070803@gmx.net> Date: Wed, 11 Feb 2009 11:23:30 +0200 From: Peter Eisentraut User-Agent: Thunderbird 2.0.0.19 (Macintosh/20081209) MIME-Version: 1.0 To: Bruce Momjian CC: Josh Berkus , pgsql-docs@postgresql.org Subject: Re: Clarification to catalog-pg-class References: <200902071929.n17JTTX13008@momjian.us> In-Reply-To: <200902071929.n17JTTX13008@momjian.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/8 X-Sequence-Number: 5054 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.