Re: Recreating a primary key

On 28 Feb 2003, Ericson Smith wrote:

> Hi,
> 
> Is there a way to re-create a primary key?
> 
> So I create tables with CREATE TABLE... PRIMARY KEY(col...) syntax. 
> 
> I later want to drop the primary key and re-create it (performance
> considerations, and to not worry about exclusive table locking with a
> rebuild index). 
> 
> The documentation says that primary keys are basically UNIQUE and NOT
> NULL keys, but checking with pg_index, I see the "indisprimary" column
> is set to true.
> 
> Any quick and dirty way to rebuild these indices?

Have you tried reindex?  It does basically just that.  And I've just 
tested to be sure, it does work on pkey indexes just fine.