Re: Template1 is locked when pgAdminIII is open

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 31 January 2005 17:29
> To: Dave Page
> Cc: Mehul Doshi-A20614; pgsql-bugs(at)postgresql(dot)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.