X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B49AC5295E for ; Sat, 28 May 2005 20:49:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66808-02 for ; Sat, 28 May 2005 23:49:35 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 53FE45293D for ; Sat, 28 May 2005 15:30:23 -0300 (ADT) Received: (qmail 12908 invoked by uid 500); 28 May 2005 18:27:54 -0000 Date: Sat, 28 May 2005 13:27:54 -0500 From: Bruno Wolff III To: David Pratt Cc: pgsql-admin@postgresql.org Subject: Re: Adding Serial Type Message-ID: <20050528182754.GA11909@wolff.to> Mail-Followup-To: Bruno Wolff III , David Pratt , pgsql-admin@postgresql.org References: <200408241143.08959.uwe@oss4u.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/286 X-Sequence-Number: 17715 On Sat, May 28, 2005 at 14:27:17 -0300, David Pratt wrote: > Pretty basic question. Is it necessary to add NOT NULL or UNIQUE NOT > NULL to SERIAL or is this implicit and unnecessary? Serials no longer generate a uniqie index by default. So in practice you will normally want to declare them as PRIMARY KEYs. However there are cases where you don't need this and the index is extra overhead.