Skip site navigation (1) Skip section navigation (2)

CREATE DATABASE fails when template1 being accessed ...

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: CREATE DATABASE fails when template1 being accessed ...
Date: 2005-05-31 17:53:41
Message-ID: 20050531145233.D933@ganymede.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers

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 ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664

Responses

pgsql-hackers by date

Next:From: Manfred KoizarDate: 2005-05-31 17:58:35
Subject: Re: Cost of XLogInsert CRC calculations
Previous:From: Marc G. FournierDate: 2005-05-31 17:45:56
Subject: Major flood of mail to lists ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group