Revision 13601
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1745 | 1745 |
BEGIN |
| 1746 | 1746 |
RETURN util.explain2notice_msg(sql); |
| 1747 | 1747 |
EXCEPTION |
| 1748 |
WHEN syntax_error THEN RETURN NULL; -- non-explainable query |
|
| 1748 |
WHEN syntax_error |
|
| 1749 |
OR invalid_cursor_definition -- "cannot open multi-query plan as cursor" |
|
| 1750 |
THEN RETURN NULL; -- non-explainable query |
|
| 1749 | 1751 |
/* don't use util.is_explainable() because the list provided by Postgres |
| 1750 | 1752 |
(http://www.postgresql.org/docs/9.3/static/sql-explain.html#AEN77691) |
| 1751 | 1753 |
excludes some query types that are in fact EXPLAIN-able */ |
Also available in: Unified diff
fix: schemas/util.sql: explain2notice_msg_if_can(): also need to catch invalid_cursor_definition ("cannot open multi-query plan as cursor")