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.