From: | Milan Oparnica <milan(dot)opa(at)gmail(dot)com> |
---|---|
To: | Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com> |
Cc: | "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Forcing "quotes" around Value field in database Parameters sheet |
Date: | 2019-09-20 08:16:33 |
Message-ID: | 01939954-54dc-7bb0-18c0-9fff95f41820@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Thanks Akshay, done.
Issue #4760 <https://redmine.postgresql.org/issues/4760> created.
:)
On 20.9.19. 09:23, Akshay Joshi wrote:
> Hi Milan
>
> Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4.
>
> On Thu, Sep 19, 2019 at 4:44 PM Milan Oparnica <milan(dot)opa(at)gmail(dot)com
> <mailto:milan(dot)opa(at)gmail(dot)com>> wrote:
>
> Hi good people :)
>
> I may have found a bug in the *Database properties* sheet
> preventing setting *Parameters* on the database level.
>
> I tried to set the *search_path* parameter on the database level.
>
> 1. Right click on the database
> 2. Select *Properties...* from the menu
> 3. Click on tab *Parameters*
> 4. Click *+* and enter /search_path/ to *Name* field
> 5. Enter /scha, schb, public, pg_catalog**/in the *Value *field
> (note, without quotes)
> 6. Click *Save*
>
> Run new query window and type *show search_path*. The result is
> *"**scha, schb, public, pg_catalog"* - together with the quotes
> aroud the string.*
> *Such path, of course, is not valid.
>
> Testing this in the same query window:
>
> *SET search_path TO scha, schb, public, pg_catalog*;
>
> *SHOW search_path*
>
> results with
>
> *scha, schb, public, pg_catalog* (without quotes, and it works as
> expected).
>
> My conclusion is that pgAdmin4 for some reason adds and stores
> quotes around the search_path value, and later uses the value as
> if it is a *single full path name*.
>
> The database server this occures on is Pg 11.
>
> Best regards,
>
> M.O.
>
>
>
> --
> *Thanks & Regards*
> *Akshay Joshi*
> *Sr. Software Architect
> *
> *EnterpriseDB Software India Private Limited*
> *Mobile: +91 976-788-8246*
From | Date | Subject | |
---|---|---|---|
Next Message | Cherio | 2019-09-20 14:07:43 | Re: Forcing "quotes" around Value field in database Parameters sheet |
Previous Message | Akshay Joshi | 2019-09-20 07:23:12 | Re: Forcing "quotes" around Value field in database Parameters sheet |