Issue Modifying search_path Parameter for Azure Database for PostgreSQL
Published Mar 13 2019 06:50 PM 1,894 Views
First published on MSDN on Oct 20, 2017
Azure Database for PostgreSQL users have recently reported an issue to us that occurs when setting a custom value for the search_path parameter from the Server parameters blade in the Azure Portal .  The issue is that this custom value is modified automatically by the service when saved.  For example:

A value entered of: "$user", public , gets transformed to """$user"", public" , as can be seen by executing the following query: SELECT reset_val FROM pg_settings WHERE name = 'search_path';

The aforementioned transformation breaks the search path in PostgreSQL.  The Product Group responsible for the Azure Database for PostgreSQL service has confirmed that this is a known issue.  While a permanent fix to address this is being worked on, the Product Group requests that users not modify the search_path parameter value at this time.  If modification is needed, please open a support case with us, as the Product Group will implement this change for you to avert this issue.  Please reference this blog post if you do.

We apologize for any inconveniences caused by this, and want everyone to know that we appreciate and value the continued feedback on our services.

Screenshots of the issue in action:

Modifying the value for the search_path parameter from the Server parameters blade on the Azure Portal.

Retrieving the search_path value via query post value modification.

Version history
Last update:
‎Mar 13 2019 06:50 PM
Updated by: