Re: Function search_path

From: Fabio Pardi <f(dot)pardi(at)portavita(dot)eu>
To: "Heinemann, Manfred (IMS)" <HeinemannM(at)imsweb(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Function search_path
Date: 2018-03-15 09:30:22
Message-ID: 5f698c34-d01d-3196-1db4-75ba8f6a37d3@portavita.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Manfred,

While at the moment I m not aware of other options (I m right now studying CVE-2018-1058 and the impact on the installations I maintain), I would focus on the 'out of memory' error.

If Postgres is correctly configured, no action you perform on the database should result in 'out of memory' errors.

Is it maybe the case to review your memory settings to avoid such conditions?

Regards,

Fabio

On 03/14/2018 08:18 PM, Heinemann, Manfred (IMS) wrote:
> We recently started upgrading to Postgres 10.3 and have run into trouble with the security change to search_path.
>
>  
>
> The release notes say:
>
> In cases where user-provided functions are indirectly executed by these programs — for example, user-provided functions in index expressions — the tighter |search_path| may result in errors, which will need to be corrected by adjusting those user-provided functions to not assume anything about what search path they are invoked under. That has always been good practice, but now it will be necessary for correct behavior. (CVE-2018-1058)
>
>  
>
> We have this issue with a custom function that calls other custom functions and that function is used in a functional index. Now autoanalyze and autovacuum fail on tables with those indices.
>
>  
>
> The simplest fix seemed to be to set the functions search_path to ‘$user’ but that has caused large updates to the indexed table to run out of memory.
>
>  
>
> Hardcoding the schema in the function would mean having to have separate functions for each schema affected. It also seems to make the function less memory efficient.
>
>  
>
> Are there other options?
>
>  
>
> Thanks,
>
> Manfred
>
>
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Information in this e-mail may be confidential. It is intended only for the addressee(s) identified above. If you are not the addressee(s), or an employee or agent of the addressee(s), please note that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this e-mail in error, please notify the sender of the error.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dhandapani Shanmugam 2018-03-15 13:15:58 Backup Tool
Previous Message Heinemann, Manfred (IMS) 2018-03-14 19:18:22 Function search_path