=20
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20
> Sent: 31 January 2005 17:29
> To: Dave Page
> Cc: Mehul Doshi-A20614; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] Template1 is locked when pgAdminIII is open=20
>=20
> Hmm. Would it be possible to teach pgAdmin to close extra connections
> to template1 whenever it's doing CREATE DATABASE?
Hmm, it's possible but not particularly friendly - it would stop any
ongoing user queries (not that there are likely to be many of those in
template1), and the server status window (which periodically selects
from pg_stat_activity among other things). I think it would be nicer for
pgAdmin to give a more helpful error message (in most cases it simply
passes on such messages as they come from the server).
Regards, Dave.