Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 307BDB5DBFB for ; Sat, 9 Jul 2011 15:45:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 81739-08 for ; Sat, 9 Jul 2011 18:45:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailout-de.gmx.net (mailout-de.gmx.net [213.165.64.22]) by mail.postgresql.org (Postfix) with SMTP id 574BBB5DBC6 for ; Sat, 9 Jul 2011 15:45:27 -0300 (ADT) Received: (qmail invoked by alias); 09 Jul 2011 18:45:24 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.102]) [88.115.218.165] by mail.gmx.net (mp012) with SMTP; 09 Jul 2011 20:45:24 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX1/uOe01c3fu8cF8/g9iZFacnvNhlzFrvzDK40sJoB 61vwtMbHXaPILL Subject: Re: cataloguing NOT NULL constraints From: Peter Eisentraut To: Alvaro Herrera Cc: pgsql-hackers@postgresql.org In-Reply-To: <20110707213401.GA27098@alvh.no-ip.org> References: <20110707213401.GA27098@alvh.no-ip.org> Content-Type: text/plain; charset="UTF-8" Date: Sat, 09 Jul 2011 21:45:23 +0300 Message-ID: <1310237123.9823.1.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.32.3 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201107/461 X-Sequence-Number: 191560 On tor, 2011-07-07 at 17:34 -0400, Alvaro Herrera wrote: > The attached patch introduces pg_constraint rows for NOT NULL > column constraints. The information schema views check_constraints and table_constraints currently make up some artificial constraint names for not-null constraints. I suppose this patch removes the underlying cause for that, so could you look into updating the information schema as well? You could probably just remove the separate union branches for not null and adjust the contype conditions.