Postgres Pro
Downloads
Home   >   mailing lists

Re: converting unique index into primary key - Mailing list pgsql-general

From Tom Lane
Subject Re: converting unique index into primary key
Date
Msg-id 23558.1103773335@sss.pgh.pa.us
Whole thread Raw
In response to converting unique index into primary key  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
"Ed L." <pgsql@bluepolka.net> writes:
> I need to convert an existing unique index on a very heavily inserted table
> into a primary key.  Alter table works, but locks the table for too long.
> As a hack, can I just set pg_index.indisprimary = 't' and
> pg_constraint.contype = 'p' for the appropriate row in each?  This is for
> 7.4.6 and 8.0beta3...

Don't forget to make the underlying columns notnull, too.

            regards, tom lane

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: migrating from mysql
Next
From: "Jon Asher"
Date:
Subject: Basic problem installing TSearch2 (full text search)