Re: Template1 is locked when pgAdminIII is open

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Mehul
> Doshi-A20614
> Sent: 31 January 2005 12:58
> To: 'pgsql-bugs(at)postgresql(dot)org'
> Subject: [BUGS] Template1 is locked when pgAdminIII is open
>
> In the PostgreSQL RC-1, whenever we have the pgAdminIII open
> and try to create a database, it says that template1 is
> locked up and hence the database cannot be created. I believe
> it shouldn't lock it up and allow the database to be created.
>
> If this bug has already been raised and fixed in subsequent
> versions, please let me know.

pgAdmin uses template1 by default as it is the only accessible database
that we can be sure will exist. There are 2 solutions to your problem:

1) Change your pgAdmin connection to use a different default database.

2) Select a different database to use as the template when creating a
new one.

Regards, Dave.