Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 942DE632B07 for ; Fri, 15 Jan 2010 02:35:30 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 09617-03 for ; Fri, 15 Jan 2010 06:35:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id 00451632601 for ; Fri, 15 Jan 2010 02:35:19 -0400 (AST) Received: from [192.168.10.3] (ASte-Genev-Bois-153-1-36-111.w83-200.abo.wanadoo.fr [83.200.26.111]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 365E33B8F5; Fri, 15 Jan 2010 07:35:18 +0100 (CET) Message-ID: <4B500CA5.5060006@lelarge.info> Date: Fri, 15 Jan 2010 07:35:17 +0100 From: Guillaume Lelarge User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0 MIME-Version: 1.0 To: Seb CC: pgsql-sql@postgresql.org Subject: Re: rename primary key References: <87hbqo11yg.fsf@kolob.sebmags.homelinux.org> <1d581afe1001141934x2c525992w2e4bcf40a3113207@mail.gmail.com> <87d41c11g4.fsf@kolob.sebmags.homelinux.org> In-Reply-To: <87d41c11g4.fsf@kolob.sebmags.homelinux.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.139 tagged_above=-10 required=5 tests=AWL=0.460, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201001/28 X-Sequence-Number: 33564 Le 15/01/2010 04:39, Seb a écrit : > On Fri, 15 Jan 2010 12:34:15 +0900, > Ian Barwick wrote: > [...] > On a related note: how come pgadmin3 shows "Indexes (0)" for such a > table, even though an index does exist for the primary key? Are these > indexes created in a separate table that is looked up by the foo table? > Primary keys are constraints. They are enforced with an index, but actually they are constraints. So we put them on the constraints nodes. There is the same behaviour for unique constraints. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com