Re: pg_database datistemplate - Mailing list pgsql-hackers

From korry
Subject Re: pg_database datistemplate
Date
Msg-id 5.1.0.14.0.20021024162747.02b93eb8@pop.starband.net
Whole thread Raw
In response to pg_database datistemplate  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
>In the docs it is mentioned for datistemplate that
>
>"If true then this database can be used in the "TEMPLATE" clause of
>CREATE DATABASE to create the new database as a clone of this one."
>
>However, one can create a database using as template another DB that has
>datistemplate set to false.
>
>In this situation, what is the point of having datistemplate?

If datistemplate is true, any user with CREATEDB privileges can clone the 
database.
If datistemplate is false, only a cluster superuser can clone the database.



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Do we still need NO_MKTIME_BEFORE_1970 ?
Next
From: Tom Lane
Date:
Subject: Re: pg_database datistemplate