pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Daniel Cristian Cruz <danielcristian@gmail.com>
To: Lista Postgres <pgsql-admin@postgresql.org>
Subject: Re: Should duplicate indexes on same column and same table
Date: Sat, 09 Dec 2006 17:45:25 -0200
Message-ID: <1165693525.5012.3.camel@debian> (raw)
In-Reply-To: <a97c77030612091117j40f9fdbejcdbb85e9aa354b8d@mail.gmail.com>
References: <a97c77030612082203j5b1dac19i96ef9932d60f375e@mail.gmail.com>
	<8397.1165647371@sss.pgh.pa.us>
	<a97c77030612082307l10eee309n6bd8ad15e992b3c2@mail.gmail.com>
	<a97c77030612082320v733b0bbav5ed2828edbc95a8d@mail.gmail.com>
	<18891.1165686391@sss.pgh.pa.us>
	<a97c77030612091117j40f9fdbejcdbb85e9aa354b8d@mail.gmail.com>

Em Dom, 2006-12-10 às 00:47 +0530, Rajesh Kumar Mallah escreveu:
> 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?

What if PostgreSQL make a NOTICE about this? The user could see it and
take some action about it.

Sincerely,
-- 
Daniel Cristian Cruz
クルズ クリスチアン ダニエル




view thread (13+ messages)  latest in thread

Message-ID: <1165693525.5012.3.camel@debian>
Permalink:  ../1165693525.5012.3.camel@debian/
Also on:    postgresql.org/message-id/1165693525.5012.3.camel@debian

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: danielcristian@gmail.com
  Subject: Re: Should duplicate indexes on same column and same table
  In-Reply-To: <1165693525.5012.3.camel@debian>
  References: <a97c77030612082203j5b1dac19i96ef9932d60f375e@mail.gmail.com> <8397.1165647371@sss.pgh.pa.us> <a97c77030612082307l10eee309n6bd8ad15e992b3c2@mail.gmail.com> <a97c77030612082320v733b0bbav5ed2828edbc95a8d@mail.gmail.com> <18891.1165686391@sss.pgh.pa.us> <a97c77030612091117j40f9fdbejcdbb85e9aa354b8d@mail.gmail.com> <1165693525.5012.3.camel@debian>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox