Role parameter search_path incorrectly quoted

From: Bruce Peret <bperet(at)pobox(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Role parameter search_path incorrectly quoted
Date: 2016-10-25 14:44:53
Message-ID: ac560072-3d5a-9ccb-28c9-da01ff17657c@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I am new to this list, so I do not know if this has been reported
already (did not find anything regarding search_path in the issue tracker).

If you use pgadmin4 to alter the search_path for a role, all queries
that do not explicitly use a schema name with tables fail. Apparently,
pgadmin4 is treating a comma-separated list of schema names as a single
name, so, for example, "public, journal" is treated as a single schema
name of 'public, journal', not 'public' and 'journal'. One must manually
alter the role in SQL to correct it.

Bruce

Win 7/x64, postgres 9.6

Modify properties for a role.

Select Parameters tab.

Click +

Select search_path from list.

Enter comma-separated list for value.

Leave database blank.

Pgadmin4 generated SQL:

ALTER ROLE myrole
RESET search_path;

ALTER ROLE myrole
SET search_path TO 'public, journal';

(value should not be quoted)

Browse pgadmin-support by date

  From Date Subject
Next Message vnicolici 2016-10-25 18:22:07 Re: pgAdmin 4 1.0-beta4 - Query Tool, Select file popup issues
Previous Message Oscar Fanelli 2016-10-25 14:19:57 Re: Servers configs location?