Re: [HACKERS] Database properties not being duplicated

2005-05-06 Thread Ben Trewern
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

[HACKERS] Database properties not being duplicated

2005-05-06 Thread Ben Trewern
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