Re: BUG #6450: PQexec stuck. - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #6450: PQexec stuck.
Date
Msg-id 4F34C4AC02000025000451BB@gw.wicourts.gov
Whole thread Raw
In response to BUG #6450: PQexec stuck.  (vipul.patel@elitecore.com)
List pgsql-bugs
[rearranged to avoid top-posting: http://idallen.com/topposting.html]

Vipul Patel  wrote:
> On Thursday 09 February 2012 10:33 PM, Kevin Grittner wrote:
>> What locks and blocking do you see when this happens?
>>
>> http://wiki.postgresql.org/wiki/Lock_Monitoring'

> I don't understand why " CREATE TABLE " Need to lock.

To protect the integrity of the system tables.

> CREATE TABLE Statement gose Hang state, whether it is execute by
> any client using (PQexec) or Standard "psql".

If you want suggestions on how to accomplish your goals in the
presence of this locking, we'll need more information.

-Kevin

pgsql-bugs by date:

Previous
From: Denish Patel
Date:
Subject: Re: BUG #6433: Pg Admin Cant open
Next
From: Vipul Patel
Date:
Subject: Re: BUG #6450: PQexec stuck.