X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB21F56441 for ; Sun, 27 Feb 2005 16:22:01 +0000 (GMT) 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 69603-10 for ; Sun, 27 Feb 2005 16:21:53 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 4A12B56439 for ; Sun, 27 Feb 2005 16:21:58 +0000 (GMT) Received: (qmail 1866 invoked by uid 500); 27 Feb 2005 16:37:41 -0000 Date: Sun, 27 Feb 2005 10:37:41 -0600 From: Bruno Wolff III To: Sam Adams Cc: pgsql-sql@postgresql.org Subject: Re: Serial and Index Message-ID: <20050227163741.GA1789@wolff.to> Mail-Followup-To: Sam Adams , pgsql-sql@postgresql.org References: <1109508892.19366.216118816@webmail.messagingengine.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1109508892.19366.216118816@webmail.messagingengine.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/337 X-Sequence-Number: 20447 On Sun, Feb 27, 2005 at 12:54:52 +0000, Sam Adams wrote: > I read at http://jamesthornton.com/postgres/FAQ/faq-english.html#4.15.1 > that when a serial is created then an index is created on the column. > However I can't seem to find this anywhere in the PoistgreSQL manual. Is > this true? Thanks. That was true with the first release that had the serial pseudo type. That was changed in later versions to provide flexibility for DBAs. In common use, a serial column is declared as the primary key and you get a unique index created without any other special declarations.