> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Mehul
> Doshi-A20614
> Sent: 31 January 2005 12:58
> To: 'pgsql-bugs@postgresql.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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
