I don't understand why " CREATE TABLE " Need to lock.
CREATE TABLE Statement gose Hang state, whether it is execute by any
client using (PQexec) or Standard "psql".
On Thursday 09 February 2012 10:33 PM, Kevin Grittner wrote:
> <vipul(dot)patel(at)elitecore(dot)com> wrote:
>> some time call of create table is stuck which is called by PQexec.
> What locks and blocking do you see when this happens?
> Have you considered getting an explicit lock with NOWAIT at the
> start of your transaction, to test whether you can currently acquire
> the rights to proceed?
>> in current stat the PQexec will stuck till anyone not vacume and
>> reindexing the DB.
> I've never seen such a situation. Are you sure that's really
> needed, as opposed to something that just takes long enough that the
> issue has cleared by the time you're finished with these steps?
In response to
pgsql-bugs by date
|Next:||From: Kevin Grittner||Date: 2012-02-10 13:18:04|
|Subject: Re: BUG #6450: PQexec stuck.|
|Previous:||From: Denish Patel||Date: 2012-02-09 22:51:58|
|Subject: Re: BUG #6433: Pg Admin Cant open|