Re: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Tom Lane
"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: >> It=B4s "" but the "query_start" column is refreshed. > Then the query runs and finishes and the problem is something to do > with the delivery of the data. Not sure after that... That seems

Re: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Scott Marlowe
On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: > > On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: > > > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > > > > SELECT * or naming all the columns locks the client > > > > application. Yesterday > > > > > I´ve wrongly said that

Re: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Scott Marlowe
On 10/11/07, Carlos H. Reimer <[EMAIL PROTECTED]> wrote: > > "Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > > > SELECT * or naming all the columns locks the client > > application. Yesterday > > > I´ve wrongly said that when naming all the columns instead of > > using the * > > > the applications

Re: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Tom Lane
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > SELECT * or naming all the columns locks the client application. Yesterday > I´ve wrongly said that when naming all the columns instead of using the * > the applications did not lock. Hm, are you sure it's not one specific column that's causing the

Re: RES: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-11 Thread Alan Hodgson
On Thursday 11 October 2007, "Carlos H. Reimer" <[EMAIL PROTECTED]> wrote: > Don´t know but apparently the problem is not an issue in the client, as > I´m able to connect and do the select * in other 8.2.4 servers. > > Don´t know what kind of tests I should do to help fixing this problem. > > Any