Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id DFBAF9FB399 for ; Thu, 12 Oct 2006 13:20:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 31228-02 for ; Thu, 12 Oct 2006 16:20:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx00.ext.bfk.de (mx00.ext.bfk.de [217.29.46.125]) by postgresql.org (Postfix) with ESMTP id 251099FB379 for ; Thu, 12 Oct 2006 13:20:15 -0300 (ADT) Received: from fweimer by bfk.de with local id 1GY3Hp-00035w-Or; Thu, 12 Oct 2006 18:19:57 +0200 To: Tom Lane Cc: Joe , Bryce Nesbitt , pgsql-sql@postgresql.org Subject: Re: Is this a bug? Deleting a column deletes the constraint. References: <452DCE97.2090706@obviously.com> <2323.1160630748@sss.pgh.pa.us> <1160645987.51367.13.camel@pampa> <10299.1160663949@sss.pgh.pa.us> From: Florian Weimer Date: Thu, 12 Oct 2006 18:19:57 +0200 In-Reply-To: <10299.1160663949@sss.pgh.pa.us> (Tom Lane's message of "Thu, 12 Oct 2006 10:39:09 -0400") Message-ID: <82d58x7bgy.fsf@mid.bfk.de> MIME-Version: 1.0 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= X-Spam-Level: X-Archive-Number: 200610/119 X-Sequence-Number: 26508 * Tom Lane: > The CREATE TABLE reference page further amplifies: > > PostgreSQL allows a table of no columns to be created (for example, > CREATE TABLE foo();). This is an extension from the SQL standard, which > does not allow zero-column tables. Zero-column tables are not in > themselves very useful, but disallowing them creates odd special cases > for ALTER TABLE DROP COLUMN, so it seems cleaner to ignore this spec > restriction. And you need the syntax for table partitioning. -- Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Durlacher Allee 47 tel: +49-721-96201-1 D-76131 Karlsruhe fax: +49-721-96201-99