I didn't see this discussed on the thread...
regrole and regnamespace don't run their output through quote_ident().
That's contrary to all the other reg* operators.
Worse, they also don't *allow* quoted input. Not only is that different
from reg*, it's the *opposite*:
select 'with spaces'::regclass;
ERROR: invalid name syntax
LINE 1: select 'with spaces'::regclass;
select '"with spaces"'::regclass;
regclass
---------------
"with spaces"
(1 row)
I think this needs to be fixed before 9.5 releases. :(
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com