Re: RES: 8.2.4 selects make applications wait indefinitely

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: carlos(dot)reimer(at)opendb(dot)com(dot)br
Cc: "Pgsql-General(at)Postgresql(dot)Org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: RES: 8.2.4 selects make applications wait indefinitely
Date: 2007-10-11 21:44:01
Message-ID: 11746.1192139041@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Carlos H. Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br> writes:
> SELECT * or naming all the columns locks the client application. Yesterday
> Ive 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randall Lucas 2007-10-11 21:59:27 Re: Coercing compound types to use generic ROW comparison operators
Previous Message Rodrigo Gonzalez 2007-10-11 21:34:34 Re: Declare Cursor