Re: dropping an index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Shuying Wang <wang(dot)shuying(dot)lists(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: dropping an index
Date: 2006-03-01 06:33:22
Message-ID: 7170.1141194802@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Michael Fuhr <mike(at)fuhr(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Christoph Della Valle 2006-03-01 06:41:25 Re: install
Previous Message Michael Fuhr 2006-03-01 05:25:56 Re: dropping an index