Re: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-10 Thread Erik Jones
On Oct 10, 2007, at 10:09 PM, Carlos H. Reimer wrote: Hi all, We are facing some problems after the migration of our PostgreSQL 8.0 to the 8.2.4 version. The entire box runs under SUSE 10.3. bd_sgp=# select version(); version ---

Re: [GENERAL] 8.2.4 selects make applications wait indefinitely

2007-10-10 Thread Tom Lane
"Carlos H. Reimer" <[EMAIL PROTECTED]> writes: > ... if you name all the table columns instead of using the * the query > runs fine, otherwise it locks. [ blink... ] You really, really, really need to provide a reproducible test case to prove that claim. > The problem only occurs if we use remot