On Mon, May 14, 2018 at 1:42 PM, Dominic Jones <jon...@xmission.com> wrote:
> Good afternoon, > > The PostgreSQL 10.4 upgrade involves changes to some function markings > (see release notes, E.1.2, second and third bullet points for specifics). > One way to make these changes is to use `ALTER FUNCTION` to change the > functions in your existing databases. While this was mainly > straightforward, I'm unclear on whether the `template0` database must be > changed in this manner or if it is automatically updated when the upgrade > is applied. The documentation indicates that in general you shouldn't > manually change the `template0` database. > If you ever go and CREATE DATABASE TEMPLATE template0 you will not get the correct markings unless you've updated template0 (w/o TEMPLATE template0 you pull from template1, probably want to update that as well). ​Related quest​ion - the post-installation instructions that are part of the news releases seem like something that should be part of the release notes...but they are not. David J.