Re: Which indexes to drop

On Wed, 2002-06-19 at 10:09, John Taylor wrote:
> On Wednesday 19 June 2002 11:35, Ron Johnson wrote:
> > On Wed, 2002-06-19 at 03:24, John Taylor wrote:
>
> > > ie:
> > > Will removing the constraint automatically drop the index
> > >
> > > Will dropping the index remove the constraint
> >
> > The docs are pretty clear about it...
> >
>
> Would you like to give some hints about where in the docs I should look ?

In http://www.postgresql.org/idocs/index.php, I searched for
"drop constraint":

http://www.postgresql.org/idocs/index.php?sql-altertable.html

Under the "Notes" section:
> To remove a PRIMARY or UNIQUE constraint, drop the relevant
> index using the DROP INDEX command.

--
+-------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://ronandheather.dhs.org:81 |
| |
| "Object-oriented programming is an exceptionally bad idea |
| which could only have originated in California." |
| --Edsger Dijkstra |
+-------------------------------------------------------------+