Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7AF2563267B for ; Wed, 18 Aug 2010 12:08:17 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 65059-06 for ; Wed, 18 Aug 2010 15:08:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.magwerks.com (mail.magwerks.com [209.248.233.131]) by mail.postgresql.org (Postfix) with ESMTP id 67FD56328F6 for ; Wed, 18 Aug 2010 12:08:08 -0300 (ADT) Received: from [192.168.1.35] by mail.magwerks.com (GMS 15.01.3664/RS2750.00.1b502c7c) with ESMTP id reaifaaa for pgsql-performance@postgresql.org; Wed, 18 Aug 2010 11:08:03 -0400 Message-ID: <4C6C050F.5050608@magwerks.com> Date: Wed, 18 Aug 2010 11:06:39 -0500 From: Justin Graf User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.11) Gecko/20100711 Thunderbird/3.0.6 MIME-Version: 1.0 To: Kevin.Grittner@wicourts.gov, depesz@depesz.com, postgres performance list Subject: Re: Are Indices automatically generated for primary keys? References: =?utf-8?Q?__<4C6BA0F6020000250003481C@gw.wicourts.gov>_?= In-Reply-To: Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit X-AntiSpam: Checked for restricted content by Gordano's AntiSpam Software X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/201 X-Sequence-Number: 40044 On 8/18/2010 9:15 AM, Clemens Eisserer wrote: > Hi, > > >> they are generated automatically. >> > Thanks depesz! > The reason why I asked was because pgAdmin doesn't display the > automatically created indices, which confused me. > > Thanks, Clemens > PGAdmin caches all database layout locally, the tree view can get very stale. So refresh the treeview with either F5 or right click an item in the treeview click refresh to rebuild the list. **snip*** All legitimate Magwerks Corporation quotations are sent in a .PDF file attachment with a unique ID number generated by our proprietary quotation system. Quotations received via any other form of communication will not be honored. CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain legally privileged, confidential or other information proprietary to Magwerks Corporation and is intended solely for the use of the individual to whom it addresses. If the reader of this e-mail is not the intended recipient or authorized agent, the reader is hereby notified that any unauthorized viewing, dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and destroy all occurrences of this e-mail immediately. Thank you.