On Mon, 14 May 2018 17:02:25 -0400 Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Dominic Jones <jonesd@xxxxxxxxxxxx> writes: > > 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. > > Yes, you'd need to fix it in template0 as well, or you risk > subsequently-created databases not having the fix. See previous > minor releases where we've given more painstaking detail about > applying catalog corrections, e.g. 9.6.4: > > https://www.postgresql.org/docs/current/static/release-9-6-4.html > > I didn't bother with spelling it all out in full detail this time, > which maybe was a mistake, but I felt that probably most users > wouldn't need to bother with these changes at all (unlike the case > where a catalog correction is security-related). > > regards, tom lane > Yes, the link does address the issue and answer the question. It looks like I didn't see the previous upgrade's discussion because the change to which it was tied didn't appear to be relevant to the database deployment involved. -- Dominic Jones <jonesd@xxxxxxxxxxxx>
