create index concurrently blocks on transactions in other databases

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: create index concurrently blocks on transactions in other databases
Date: 2007-09-06 10:43:40
Message-ID: 20070906104340.GA7148@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

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.

i dont really see why this would be neccessary - i understand that we
need to wait for transactions in the same db, but waiting for
transaction in another database?

i tested it on 8.2.4 and 8.3devel from cvs-head, fetched 3 days ago.

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA. here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message László-Róbert, Albert 2007-09-06 10:47:55 hu_HU.UTF8 case insensitive search fail to return values
Previous Message Unicode converter buffer overflow in psqlodbc driver 2007-09-06 09:23:56 BUG #3601: When we try to connect to postgres ti shows Unicode converter buffer overflow error.

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-09-06 13:36:57 Re: HOT patch - version 15
Previous Message Heikki Linnakangas 2007-09-06 10:05:49 Re: HOT patch - version 15