Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Fix search_path to a safe value during maintenance operations. - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: pgsql: Fix search_path to a safe value during maintenance operations.
Date
Msg-id 3c6f92439fef0137b56d68eae54256296bda9320.camel@j-davis.com
Whole thread Raw
In response to Re: pgsql: Fix search_path to a safe value during maintenance operations.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: pgsql: Fix search_path to a safe value during maintenance operations.
List pgsql-hackers
Tree view 
On Tue, 2023-08-01 at 11:16 -0700, David G. Johnston wrote:
> They can use ALTER FUNCTION and the existing "FROM CURRENT"
> specification to get back to current behavior if desired.

The current behavior is that the search_path comes from the environment
each execution. FROM CURRENT saves the search_path at definition time
and uses that each execution.

Regards,
    Jeff Davis

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: stats test intermittent failure
Next
From: "David G. Johnston"
Date:
Subject: Re: pgsql: Fix search_path to a safe value during maintenance operations.