Joshua D. Drake wrote: > Tom Lane wrote: > >Dave Cramer <[EMAIL PROTECTED]> writes: > >>On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote: > >>>Yes they are using a connection pool. A java based one. > > > >>Since java has it's own protocol implementation, this is totally > >>unrelated to any libpq error messages. > > > >Another important point that we've not been given information on: > >when pgAdmin/libpq starts failing like this, exactly what is happening > >with the connection pool? Is it still able to issue queries, and > >if not what happens exactly? > > No, when this happens everything stops. The only thing they get back is > that message until they reboot the server. The web app (via > java/connection pool), pgAdmin both give the same error.
Actually Dave Cramer told me that if the postmaster was stopped and then restarted, it would start answering fine again. Which would make a lot of sense. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
