Revision 13496
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1675 | 1675 |
|
| 1676 | 1676 |
CREATE FUNCTION explain(sql text) RETURNS SETOF text |
| 1677 | 1677 |
LANGUAGE sql |
| 1678 |
SET client_min_messages TO 'error' |
|
| 1678 | 1679 |
AS $_$ |
| 1680 |
/* `client_min_messages = ERROR`: EXPLAIN apparently runs IMMUTABLE functions in |
|
| 1681 |
the query, so this prevents displaying any log messages printed by them */ |
|
| 1679 | 1682 |
SELECT util.eval2set($$EXPLAIN $$||$1, verbose_ := false) |
| 1680 | 1683 |
$_$; |
| 1681 | 1684 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: explain(): don't display any log messages printed by IMMUTABLE functions in the query, which EXPLAIN apparently runs