Database properties not being duplicated

From: "Ben Trewern" <ben(dot)trewern(at)_nospam_mowlem(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Database properties not being duplicated
Date: 2005-05-06 11:34:12
Message-ID: d5fki5$2qpk$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 of them get carried accross.

Regards,

Ben

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Sabino Mullane 2005-05-06 11:34:49 Re: Views, views, views! (long)
Previous Message Geoffrey 2005-05-06 11:28:09 Re: [HACKERS] A real puzzler: ANY way to recover?