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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
