Обсуждение: Re: [BUGS] create index concurrently blocks on transactions in other databases

On Thu, 2007-09-06 at 21:47 +0100, Simon Riggs wrote:
> On Thu, 2007-09-06 at 15:55 -0400, Tom Lane wrote:

> > This would have been painful to fix in 8.2 but it seems relatively
> > trivial in HEAD --- we just need another filter option in
> > GetCurrentVirtualXIDs.

Patch enclosed. Tested manually on same/different databases.

No docs changed, nor test cases added.

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

Simon Riggs <simon@2ndquadrant.com> writes:
> On Thu, 2007-09-06 at 15:55 -0400, Tom Lane wrote:
>> This would have been painful to fix in 8.2 but it seems relatively
>> trivial in HEAD --- we just need another filter option in
>> GetCurrentVirtualXIDs.

> Patch enclosed. Tested manually on same/different databases.
> No docs changed, nor test cases added.

Applied.  I changed the docs thus

-     addition it must wait for all existing transactions to terminate.  Thus
+     addition it must wait for all existing transactions that could potentially
+     use the index to terminate.  Thus

which is a bit vague about the details but perhaps that's just as well.

            regards, tom lane