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