Bruce Momjian <br...@momjian.us> writes: > On Fri, Jan 19, 2018 at 02:54:25PM -0500, Tom Lane wrote: >> Command was: DROP DATABASE "template1";
> Uh, the oid of the template1 database is 1, and I assume we would want > to preserve that too. I don't feel any huge attachment to that. In the first place, under this proposal recreating template1 is something you would only need to do if you weren't satisfied with its default properties as set by initdb. Which ought to be a minority of users. In the second place, if you are changing those properties from the way initdb set it up, it's not really virgin template1 anymore, so why shouldn't it have a new OID? regards, tom lane