[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