Re: CREATE DATABASE fails when template1 being accessed ... - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: CREATE DATABASE fails when template1 being accessed ...
Date
Msg-id 20050531185426.GA13127@wolff.to
Whole thread Raw
In response to CREATE DATABASE fails when template1 being accessed ...  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-hackers
On Tue, May 31, 2005 at 14:53:41 -0300, "Marc G. Fournier" <scrappy@postgresql.org> wrote:
> 
> 
> ERROR:  source database "template1" is being accessed by other users
> 
> Why is this not allowed?  Not that there is generally a reason to be in 
> template1, but am curious as to why it prevents a new DB from being 
> created if someone is connected to it ...

Because if someone changes something in the database while it is being
copied, the newly created database will probably be messed up.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CREATE DATABASE fails when template1 being accessed ...
Next
From: Alvaro Herrera
Date:
Subject: Re: CREATE DATABASE fails when template1 being accessed ...