Re: [BUGS] BUG #6450: PQexec stuck.

2012-02-10 Thread Vipul Patel
Hi, 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". Regards, Vipul Patel. On Thursday 09 February 2012 10:33 PM, Kevin Grittner wrote: wrote: some time call o

Re: [BUGS] BUG #6450: PQexec stuck.

2012-02-10 Thread Kevin Grittner
[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 " CRE

Re: [BUGS] BUG #6450: PQexec stuck.

2012-02-09 Thread Kevin Grittner
wrote: > some time call of create table is stuck which is called by PQexec. What locks and blocking do you see when this happens? http://wiki.postgresql.org/wiki/Lock_Monitoring' Have you considered getting an explicit lock with NOWAIT at the start of your transaction, to test whether you

[BUGS] BUG #6450: PQexec stuck.

2012-02-09 Thread vipul . patel
The following bug has been logged on the website: Bug reference: 6450 Logged by: Vipul Patel Email address: vipul.pa...@elitecore.com PostgreSQL version: 8.4.5 Operating system: linux Description: hi, I am using the PostgreSQL 8.4.5, I wrote C programm which Creat