9.5 BLOCKER: regrole and regnamespace and quotes
| От | Jim Nasby |
|---|---|
| Тема | 9.5 BLOCKER: regrole and regnamespace and quotes |
| Дата | |
| Msg-id | 5689CBD8.9020306@BlueTreble.com обсуждение исходный текст |
| Ответы |
Re: 9.5 BLOCKER: regrole and regnamespace and quotes
Re: 9.5 BLOCKER: regrole and regnamespace and quotes |
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: