From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Mehul Doshi-A20614" <mehul(at)motorola(dot)com>, <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: Template1 is locked when pgAdminIII is open |
Date: | 2005-01-31 13:05:22 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E45287A9@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> -----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.
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2005-01-31 13:17:38 | Re: postgresql-7.4.6-2PGDG.src.rpm broken for Redhat 7,8 |
Previous Message | Geoffrey | 2005-01-31 13:05:01 | Re: postgresql-7.4.6-2PGDG.src.rpm broken for Redhat 7,8 |