Re: Create user/create database outside template1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Create user/create database outside template1
Date: 2000-05-25 16:40:47
Message-ID: 23308.959272847@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-05-25 16:42:24 Re: Create user/create database outside template1
Previous Message Tom Lane 2000-05-25 16:28:40 Re: parser oddity (t.count)