>>>>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> Raj Mathur <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly