Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id ED5F39FA387 for ; Wed, 13 Dec 2006 19:57:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 67531-08 for ; Wed, 13 Dec 2006 19:57:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id A5D409FA0B7 for ; Wed, 13 Dec 2006 19:57:17 -0400 (AST) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id kBDNvBrp028498 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Wed, 13 Dec 2006 15:57:12 -0800 Subject: Re: Should duplicate indexes on same column and same From: "Joshua D. Drake" To: Tom Lane Cc: Bruce Momjian , Rajesh Kumar Mallah , Lista Postgres In-Reply-To: <13302.1166054153@sss.pgh.pa.us> References: <200612132349.kBDNn7S28850@momjian.us> <1166054092.6494.4.camel@localhost.localdomain> <13302.1166054153@sss.pgh.pa.us> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Wed, 13 Dec 2006 15:59:09 -0800 Message-Id: <1166054349.6494.6.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Wed, 13 Dec 2006 15:57:12 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/193 X-Sequence-Number: 23985 On Wed, 2006-12-13 at 18:55 -0500, Tom Lane wrote: > "Joshua D. Drake" writes: > >> The cost of preventing every stupid database use is too high. > > > Although a notice that says: > > NOTICE: CREATE DUPLICATE INDEX y on test (col1); > > Probably isn't out of order. > > You're omitting the (probably) several pages of C code that would be > needed to detect whether the index is really a duplicate or not. Bah, hmmm maybe a perl script in contrib :) Sincerely, Joshua D. Drake > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate