Thread: [pgAdmin III] #169: SET search_path = value
#169: SET search_path = value
-----------------------------+----------------------------------------------
Reporter: brsa | Owner: dpage
Type: bug | Status: new
Priority: critical | Milestone:
Component: pgadmin | Version: 1.10
Keywords: browser sqlpane | Platform: all
-----------------------------+----------------------------------------------
The syntax for the SQL command SET requires a value, not a string (with
single quotes) in a number of cases. Not exactly intuitive but that's how
it is.
The reverse engineered code for roles falls victim to this pitfall and
adds single quotes, which is wrong.
-- demo --
-- I say:
CREATE ROLE test;
ALTER ROLE test SET search_path=test, public;
-- pgAdmin says:
CREATE ROLE test
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
ALTER ROLE test SET search_path='test, public'; -- note the quotes!
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/169>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
#169: SET search_path = value
-----------------------------+----------------------------------------------
Reporter: brsa | Owner: dpage
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: browser sqlpane | Platform: all
-----------------------------+----------------------------------------------
Changes (by brsa):
* priority: critical => minor
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/169#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
#169: SET search_path = value
-----------------------------+----------------------------------------------
Reporter: brsa | Owner: gleu
Type: bug | Status: assigned
Priority: minor | Milestone: 1.10.3
Component: pgadmin | Version: 1.10
Keywords: browser sqlpane | Platform: all
-----------------------------+----------------------------------------------
Changes (by gleu):
* owner: dpage => gleu
* status: new => assigned
* milestone: => 1.10.3
Comment:
Fixed in r8287 and r8290.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/169#comment:2>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
#169: SET search_path = value
----------------------+-----------------------------------------------------
Reporter: brsa | Owner: gleu
Type: bug | Status: closed
Priority: minor | Milestone: 1.10.3
Component: pgadmin | Version: 1.10
Resolution: fixed | Keywords: browser sqlpane
Platform: all |
----------------------+-----------------------------------------------------
Changes (by gleu):
* status: assigned => closed
* resolution: => fixed
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/169#comment:3>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III