> -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED] > 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 > > 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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
