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 5064052AAD for ; Sun, 27 Feb 2005 17:43:16 +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 90559-04 for ; Sun, 27 Feb 2005 17:43:05 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.203]) by svr1.postgresql.org (Postfix) with ESMTP id D4D3C56449 for ; Sun, 27 Feb 2005 17:43:10 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id j1so754577rnf for ; Sun, 27 Feb 2005 09:43:23 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=UbHAZZ5MtIyIq+MGWmnwLq9+0Oa+93QL0oDvS2QEV0Vm+UXNKqChubH99TYcq+AMyzJXhaGYuFNaI4QorfV3vNR3DVH2/9QkGBiEddQXoV52cKe/dckzq6/GwfJfOh3HNUed+eiyMpzLAq8hE5qq4uyhVSySF4cu0UQfZ71KFzE= Received: by 10.38.88.59 with SMTP id l59mr8145rnb; Sun, 27 Feb 2005 09:43:23 -0800 (PST) Received: by 10.38.126.43 with HTTP; Sun, 27 Feb 2005 09:43:23 -0800 (PST) Message-ID: Date: Sun, 27 Feb 2005 17:43:23 +0000 From: Mike Rylander Reply-To: Mike Rylander To: Sam Adams , PostgreSQL SQL Subject: Re: Serial and Index In-Reply-To: <1109508892.19366.216118816@webmail.messagingengine.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <1109508892.19366.216118816@webmail.messagingengine.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/339 X-Sequence-Number: 20449 On Sun, 27 Feb 2005 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. The FAQ entry is incorrect. If you make your SERIAL column the PRIMARY KEY of the table, however, a UNIQUE index will be created. -- Mike Rylander mrylander@gmail.com GPLS -- PINES Development Database Developer http://open-ils.org