Re: Recreating a primary key

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?
> 
> 

Not sure I understand what you mean - whatever "quick and dirty" way you choose to rebuild an index, it has to lock the table,
because otherwise the resulting index will be incorrect...