SET search_path = value

[brsa]

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!

[gleu]

Fixed in r8287 and r8290.