Re: pg_restore dependencies

Andrew Dunstan <andrew@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