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)
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? |