The old versions should definitely not have it turned on by default. I
probably was not as clear as I thought in bringing out that point..
For upcoming next ones the distributors may want to turn it on for
some more security-conscious ("enterprize") distributions.
-- Hannu
On Sat, Jun 25, 2022 at 2:08 AM David G. Johnston
<[email protected]> wrote:
>
>
>
> On Friday, June 24, 2022, Gurjeet Singh <[email protected]> wrote:
>>
>> On Fri, Jun 24, 2022 at 4:13 PM Andres Freund <[email protected]> wrote:
>> > On 2022-06-25 00:08:13 +0200, Hannu Krosing wrote:
>>
>> > > 3) should this be back-patched (we can provide batches for all
>> > > supported PgSQL versions)
>> >
>> > Err, what?
>>
>> Translation: Backpatching these changes to any stable versions will
>> not be acceptable (per the project versioning policy [1]), since these
>> changes would be considered new feature. These changes can break
>> installations, if released in a minor version.
>>
>
> No longer having the public schema in the search_path was a feature that got
> back-patched, with known bad consequences, without any way for the DBA to
> voice their opinion on the matter. This proposal seems similar enough to at
> least ask the question, with full DBA control and no known bad consequences.
>
> David J.
>
