summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/errors.out9
-rw-r--r--src/test/regress/sql/errors.sql6
2 files changed, 10 insertions, 5 deletions
diff --git a/src/test/regress/expected/errors.out b/src/test/regress/expected/errors.out
index 7dd8a5b33e..a525aa2f93 100644
--- a/src/test/regress/expected/errors.out
+++ b/src/test/regress/expected/errors.out
@@ -441,9 +441,12 @@ ERROR: syntax error at or near "NUL"
LINE 16: ...L, id2 TEXT NOT NULL PRIMARY KEY, id3 INTEGER NOT NUL, id4 I...
^
-- Check that stack depth detection mechanism works and
--- max_stack_depth is not set too high
+-- max_stack_depth is not set too high. The full error report is not
+-- very stable, so show only SQLSTATE and primary error message.
create function infinite_recurse() returns int as
'select infinite_recurse()' language sql;
-\set VERBOSITY terse
+\set VERBOSITY sqlstate
select infinite_recurse();
-ERROR: stack depth limit exceeded
+ERROR: 54001
+\echo :LAST_ERROR_MESSAGE
+stack depth limit exceeded
diff --git a/src/test/regress/sql/errors.sql b/src/test/regress/sql/errors.sql
index 792c29c64b..86b672538a 100644
--- a/src/test/regress/sql/errors.sql
+++ b/src/test/regress/sql/errors.sql
@@ -366,8 +366,10 @@ NOT
NULL);
-- Check that stack depth detection mechanism works and
--- max_stack_depth is not set too high
+-- max_stack_depth is not set too high. The full error report is not
+-- very stable, so show only SQLSTATE and primary error message.
create function infinite_recurse() returns int as
'select infinite_recurse()' language sql;
-\set VERBOSITY terse
+\set VERBOSITY sqlstate
select infinite_recurse();
+\echo :LAST_ERROR_MESSAGE