[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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to