Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F13649FA387 for ; Wed, 13 Dec 2006 19:53:11 -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 67552-04 for ; Wed, 13 Dec 2006 19:52:57 -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 1333F9FA162 for ; Wed, 13 Dec 2006 19:53:06 -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 kBDNqscH028384 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Wed, 13 Dec 2006 15:52:55 -0800 Subject: Re: Should duplicate indexes on same column and same From: "Joshua D. Drake" To: Bruce Momjian Cc: Rajesh Kumar Mallah , Tom Lane , Lista Postgres In-Reply-To: <200612132349.kBDNn7S28850@momjian.us> References: <200612132349.kBDNn7S28850@momjian.us> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Wed, 13 Dec 2006 15:54:52 -0800 Message-Id: <1166054092.6494.4.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:52:56 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/191 X-Sequence-Number: 23983 > > Sorry , > > i guess i digressed . > > Lemme put the question once again. > > > > psql> CREATE INDEX x on test (col1); > > psql> CREATE INDEX y on test (col1); > > > > What is (are) the downsides of disallowing the > > second index. which is *exactly* same as > > previous? > > 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. Sincerely, Joshua D. Drake > -- === 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