Re: dropping an index - Mailing list pgsql-novice

From Tom Lane
Subject Re: dropping an index
Date
Msg-id 7170.1141194802@sss.pgh.pa.us
Whole thread Raw
In response to Re: dropping an index  (Michael Fuhr <mike@fuhr.org>)
List pgsql-novice
Michael Fuhr <mike@fuhr.org> writes:
> On Wed, Mar 01, 2006 at 04:11:07PM +1100, Shuying Wang wrote:
>> Is it possible to drop and recreate an index on a column that's
>> actually a primary key for a table in PostgreSQL 7.3 ? I couldn't
>> figure that out from the documentation.

> You can use ALTER TABLE to drop and later add the primary key
> constraint.  Is that what you mean?

I think what's probably wanted here is REINDEX ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: dropping an index
Next
From: Christoph Della Valle
Date:
Subject: Re: install