| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: create index concurrently blocks on transactions in other databases |
| Date: | 2007-09-06 21:54:08 |
| Message-ID: | 1189115648.4175.433.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-09-06 21:55:27 | Re: [BUGS] create index concurrently blocks on transactions in other databases |
| Previous Message | Simon Riggs | 2007-09-06 20:47:29 | Re: create index concurrently blocks on transactions in other databases |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-09-06 21:55:27 | Re: [BUGS] create index concurrently blocks on transactions in other databases |
| Previous Message | Simon Riggs | 2007-09-06 20:47:29 | Re: create index concurrently blocks on transactions in other databases |