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;
 "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

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to