Re: Database properties not being duplicated

OK. It just doesn't seem obvious why.

Regards,

Ben
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:14998(dot)1115394461(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "Ben Trewern" <ben(dot)trewern(at)_nospam_mowlem(dot)com> writes:
>> If I have one database say db1 and then do:
>> ALTER DATABASE db1 SET DateStyle=iso, dmy;
>> Then do
>> CREATE DATABASE db2 TEMPLATE db1;
>> the DateStyle does not get carried accross to the new database. Is this
>> a
>> bug?
>
> No, not in my view. We don't propagate any of the other pg_database
> columns (eg, name, owner, permissions) either.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>