Re: [HACKERS] SERIAL + PRIMARY KEY = redundant indexes

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] SERIAL + PRIMARY KEY = redundant indexes
Date: 1999-05-11 16:10:53
Message-ID: 3738568D.A2CF348F@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

fwiw, there is this comment in the code:

* Note that this code does not currently look for all possible
redundant cases
* and either ignore or stop with warning. The create might fail
later when
* names for indices turn out to be duplicated, or a user might have
specified
* extra useless indices which might hurt performance. - thomas
1997-12-08

But I should (probably) be able to fix this particular case.

- Tom

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ross J. Reedstrom 1999-05-11 16:52:33 Re: [INTERFACES] Bug in psql?
Previous Message Bruce Momjian 1999-05-11 16:04:32 Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604