CREATE INDEX CONCURRENTLY is not a transactional statement. If you want to create an index inside a transaction it will block all writes to the table until the

CREATE INDEX CONCURRENTLY is not a transactional statement. If you want to create an index inside a transaction it will block all writes to the table until the index is created, which can take a rather long time on large tables.