Andrew Dunstan <and...@dunslane.net> writes: > Tom Lane wrote: >> Doesn't that eliminate any chance of running two CREATE INDEXes >> concurrently on the same table?
> No, since neither of them will have any locking dependencies, which are > only for items that take an exclusive lock on the table(s), such as FK > constraints. In that case a CREATE INDEX would also fail to be seen as conflicting with an ALTER ADD FOREIGN KEY, which I thought was the nub of Josh's complaint. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers