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 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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster