Skip site navigation (1) Skip section navigation (2)

Re: Which indexes to drop

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Which indexes to drop
Date: 2002-06-19 23:41:47
Message-ID: 1024530108.20217.5.camel@rebel (view raw or flat)
Thread:
Lists: pgsql-novice
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                                          |
+-------------------------------------------------------------+


In response to

pgsql-novice by date

Next:From: Hiroki TakadaDate: 2002-06-20 04:40:14
Subject: Re: Need to install libpq++
Previous:From: Tom AnsleyDate: 2002-06-19 22:15:36
Subject: Need to install libpq++

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group