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.l.johnson@cox.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                                          |
+-------------------------------------------------------------+