Re: Create user/create database outside template1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Create user/create database outside template1
Date
Msg-id 23308.959272847@sss.pgh.pa.us
Whole thread Raw
In response to Create user/create database outside template1  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Create user/create database outside template1  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: parser oddity (t.count)
Next
From: Bruce Momjian
Date:
Subject: Re: Create user/create database outside template1