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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 |
+-------------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroki Takada | 2002-06-20 04:40:14 | Re: Need to install libpq++ |
Previous Message | Tom Ansley | 2002-06-19 22:15:36 | Need to install libpq++ |