Revision 13601
Added by Aaron Marcuse-Kubitza about 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")