Re: create index concurrently blocks on transactions in other databases - Mailing list pgsql-bugs

On Thu, 2007-09-06 at 12:43 +0200, hubert depesz lubaczewski wrote:
> steps to reproduce:
> session1: connect using user1 to database1.
> session2: connect using user2 to database2.
> session1: create table x ( y int);
> session2: begin;
> session1: create index concurrently q on x(y);
> it hangs.
> session2: rollback/commit;
> session1: finishes.

BTW, this is a brilliant example of why we need Concurrent psql.

It's very natural to express test cases in the manner shown.

--
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com