Re: Template1 is locked when pgAdminIII is open

=20

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

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.