10.4 upgrade, function markings, and template0

From: Dominic Jones <jonesd(at)xmission(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 10.4 upgrade, function markings, and template0
Date: 2018-05-14 20:42:44
Message-ID: 20180514144244.fe352659f5085e209594f3ff@xmission.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

--
Dominic Jones <jonesd(at)xmission(dot)com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-05-14 20:58:44 Re: 10.4 upgrade, function markings, and template0
Previous Message Jonathan Marks 2018-05-14 19:31:42 Re: Rapid disk usage spikes when updating large tables with GIN indexes