psql's is_select_command is naive

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
psql's is_select_command is naive
Дата
в 23:09:33
Msg-id
AANLkTimMSbRbkpVNcv3DInY9i1DpsxznIgE6bz5CU2Xk@mail.gmail.com
Список
Дерево обсуждения
psql's is_select_command is naive Robert Haas <robertmhaas@gmail.com>
Re: psql's is_select_command is naive Stephen Frost <sfrost@snowman.net>
Re: psql's is_select_command is naive Tom Lane <tgl@sss.pgh.pa.us>
Re: psql's is_select_command is naive Robert Haas <robertmhaas@gmail.com>
Re: psql's is_select_command is naive Bruce Momjian <bruce@momjian.us>
It knows that queries beginning with "select" or "values" are select
commands, but it seems not to be clued in about "table" and "with".

For now, we can probably get by with just adding those to the list of
things it checks for.  But I wonder what we'll do about this if we
ever get CTEs for insert/update/delete statements...  you'd have to
parse the whole darn thing to figure out whether it was WITH...SELECT
or WITH...INSERT or WITH...INSERT...RETURNING.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

В списке pgsql-hackers по дате отправления
От: Mark Kirkwood
Дата:
От: Stephen Frost
Дата:
Сообщение: Re: ExecutorCheckPerms() hook
FAQ