On Thu, 25 May 2000, Bruce Momjian wrote:
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > What happens if people issue create user or create database outside
> > > template1. Do we need to prevent it? Seems they work, but am not sure
> > > it is OK. Do we need to add a check?
> > Works fine, no, and no. The reason the scripts like to connect to
> > template1 is that it's the only database they can be sure is there.
> > But the commands themselves don't care where you're connected.
> Well, thanks. I was going over that for my book. If I do createdb from
> another database, I guess I get a copy of that database, right?
> Interesting feature that I am sure few people realize.
Say what? That might explain a few things.
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2000-05-25 17:05:16|
|Subject: Re: Create user/create database outside template1 |
|Previous:||From: Bruce Momjian||Date: 2000-05-25 16:42:24|
|Subject: Re: Create user/create database outside template1|