[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