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)
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. |
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 |