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 >

10.4 upgrade, function markings, and template0

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