Any way to add a PK "under the covers" for PostgreSQL version 8.3?
On 01/06/2014 03:53 PM, Thomas Kellerer wrote:
CS DBA wrote on 06.01.2014 23:30:
We have a few very large tables with unique indexes on a column but
the column is not defined as the Primary Key. Can we add a PK
constraint via updates to the system catalogs so we can avoid the
lengthy checks that would take place if we ran "alter table add
constraint primary key...."
You can add a PK constraint with the "USING INDEX" clause:
alter table foo
add primary key
using index unique_index_name;
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
