OK. It just doesn't seem obvious why.
Regards,
Ben
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Ben Trewern" <[EMAIL PROTECTED]> writes:
>> If I have one database say db1 and then do:
>> ALTER DATABASE db1 SET D
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? It seems not to matter which properties I set ie search_path, TimeZone
etc. none o