Le 25/04/2011 12:44, Piotr Czekalski a écrit : > [...] > First of all - Happy Easter to all of the readers! > > I've got a question related to the reconnection procedure, when > connection lost. > It is quite easy to do in the main PgAdmin window, but how do I > reconnect to the same database when operating within SQL Query window? > When connection lost, I do can connect to the other databases using > combobox located on the toolbar, but can't reconnect to the one that was > used before connection was lost. > > Steps to reproduce: > 1. Configure connections at least to the two databases, connect to the > first of them. > 2. Open SQL Query window, write and execute some query. > 3. Disconnect and reconnet your network connection. > 4. Your connection is dropped - try to reconnect -> impossible, but you > still can connect to the other database than in point 1. >
Yeah, if the selected parameters are the same than an old connection, then we use the old connection, so that we don't get too many connections to the same handle (host/database/user). We should probably first check if the connection is still available and reconnect otherwise. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support