Re: pg_restore dependencies

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_restore dependencies
Date: 2009-04-10 21:25:15
Message-ID: 1465.1239398715@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> Yeah. I think the correct logic is roughly this: When considering if a
> candidate item has a locking conflict with a running item, then if
> *either* of them has a locking dependency that coincides with *any*
> dependency of the other item, then the candidate is rejected. The
> principle is that we don't give any item a chance to block on a lock.

Doesn't that eliminate any chance of running two CREATE INDEXes
concurrently on the same table?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-04-10 21:33:50 Re: pg_restore dependencies
Previous Message Tom Lane 2009-04-10 21:24:17 Re: Re: [BUGS] BUG #4027: backslash escapingnotdisabledinplpgsql