>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> Raj Mathur <raju@linux-delhi.org> writes:
>> I'm consistently getting into a situation where the database
>> client just goes to sleep in a query after some number of
>> queries in quick succession. Using PostgreSQL 7.2.3 on Red Hat
>> Linux 8.0. The postgres process shows up as ``idle in
>> transaction'' in a ps.
Tom> In that case, the backend is waiting for input from the
Tom> client.
Tom> If the client thinks it is waiting for the backend, I'd
Tom> wonder about a missing "fflush" or something like that. What
Tom> client software are you using?
Using Perl 5.8.0 and DBI 1.32. Any known problems with this setup?
-- Raju
--
Raj Mathur raju@kandalaya.org http://kandalaya.org/
GPG: 78D4 FC67 367F 40E2 0DD5 0FEF C968 D0EF CC68 D17F
All your domain are belong to us.
It is the mind that moves