On 10/15/2013 02:31 PM, Andres Freund wrote: > On 2013-10-15 11:55:06 -0700, Josh Berkus wrote: >> Also, because you can't INDEX CONCURRENTLY a PK, I've been building a >> lot of databases which have no PKs, only UNIQUE indexes. > > You know that you can add prebuilt primary keys using ALTER TABLE > ... ADD CONSTRAINT ... PRIMARY KEY (...) USING indexname?
That still requires an ACCESS EXCLUSIVE lock, and then can't be dropped using DROP INDEX CONCURRENTLY. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
