Re: 10.4 upgrade, function markings, and template0

On Mon, May 14, 2018 at 1:42 PM, Dominic Jones <jonesd(at)xmission(dot)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.