psql's is_select_command is naive
От
Robert Haas
Тема
psql's is_select_command is naive
Дата
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 по дате отправления