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?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 25 May 2000 12:18:24 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Create user/create database outside template1
Bruce Momjian <pgman@candle.pha.pa.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.

			regards, tom lane

Thu, 25 May 2000 12:40:47 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Create user/create database outside template1 
> Bruce Momjian <pgman@candle.pha.pa.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.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 25 May 2000 12:42:24 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Create user/create database outside template1
On Thu, 25 May 2000, Bruce Momjian wrote:

> > Bruce Momjian <pgman@candle.pha.pa.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.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.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
==========================================================================




Thu, 25 May 2000 13:05:03 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: Create user/create database outside template1
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 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? 

No, it's always a copy of template1.  CREATE DATABASE really doesn't
care which database you're connected to (nor does CREATE USER).

			regards, tom lane

Thu, 25 May 2000 13:05:16 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Create user/create database outside template1 
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > 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? 
> 
> No, it's always a copy of template1.  CREATE DATABASE really doesn't
> care which database you're connected to (nor does CREATE USER).

Yes, I see that.  Interesting.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thu, 25 May 2000 13:05:40 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Create user/create database outside template1