Re: 10.4 upgrade, function markings, and template0

2018-05-14 Thread Michael Paquier
On Mon, May 14, 2018 at 05:22:39PM -0400, Tom Lane wrote: > Maybe it'd be worth building some sort of infrastructure that would > allow this to be done at a lower level. It's not hard to imagine > an autovacuum-like or bgworker-based thingy that could run around > and apply a given SQL script in e

Re: 10.4 upgrade, function markings, and template0

2018-05-14 Thread Dominic Jones
On Mon, 14 May 2018 17:02:25 -0400 Tom Lane wrote: > Dominic Jones 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 ch

Re: 10.4 upgrade, function markings, and template0

2018-05-14 Thread Adrian Klaver
On 05/14/2018 02:22 PM, Tom Lane wrote: Adrian Klaver writes: On 05/14/2018 02:02 PM, Tom Lane wrote: 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

Re: 10.4 upgrade, function markings, and template0

2018-05-14 Thread Tom Lane
Adrian Klaver writes: > On 05/14/2018 02:02 PM, Tom Lane wrote: >> 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 correctio

Re: 10.4 upgrade, function markings, and template0

2018-05-14 Thread Adrian Klaver
On 05/14/2018 02:02 PM, Tom Lane wrote: Dominic Jones 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 yo

Re: 10.4 upgrade, function markings, and template0

2018-05-14 Thread Tom Lane
Dominic Jones 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

Re: 10.4 upgrade, function markings, and template0

2018-05-14 Thread David G. Johnston
On Mon, May 14, 2018 at 1:42 PM, Dominic Jones 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 >