Skip site navigation (1) Skip section navigation (2)

Re: BUG #6450: PQexec stuck.

From: Vipul Patel <vipul(dot)patel(at)elitecore(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6450: PQexec stuck.
Date: 2012-02-10 08:24:35
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
             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".

Vipul Patel.

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?
> -Kevin

In response to

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2012-02-10 13:18:04
Subject: Re: BUG #6450: PQexec stuck.
Previous:From: Denish PatelDate: 2012-02-09 22:51:58
Subject: Re: BUG #6433: Pg Admin Cant open

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group