Add PK constraint to a Unique Index via updating system catalogs? - Mailing list pgsql-general

From CS DBA
Subject Add PK constraint to a Unique Index via updating system catalogs?
Date
Msg-id 52CB2EA0.1080804@consistentstate.com
Whole thread Raw
Responses Re: Add PK constraint to a Unique Index via updating system catalogs?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Hi All;

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...."


Thanks in advance





pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: authentication failure
Next
From: Thomas Kellerer
Date:
Subject: Re: Add PK constraint to a Unique Index via updating system catalogs?