Postgres Pro
Downloads
Home   >   mailing lists

Re: RES: 8.2.4 selects make applications wait indefinitely - Mailing list pgsql-general

From Tom Lane
Subject Re: RES: 8.2.4 selects make applications wait indefinitely
Date
Msg-id 11746.1192139041@sss.pgh.pa.us
Whole thread Raw
In response to RES: 8.2.4 selects make applications wait indefinitely  ("Carlos H. Reimer" <carlos.reimer@opendb.com.br>)
Responses RES: RES: 8.2.4 selects make applications wait indefinitely
List pgsql-general
Tree view 
"Carlos H. Reimer" <carlos.reimer@opendb.com.br> 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
problem?

            regards, tom lane

pgsql-general by date:

Previous
From: Rodrigo Gonzalez
Date:
Subject: Re: Declare Cursor
Next
From: Randall Lucas
Date:
Subject: Re: Coercing compound types to use generic ROW comparison operators