aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/plpgsql.out4
-rw-r--r--src/test/regress/sql/plpgsql.sql2
2 files changed, 4 insertions, 2 deletions
diff --git a/src/test/regress/expected/plpgsql.out b/src/test/regress/expected/plpgsql.out
index 29f9e86d560..26f6e4394f4 100644
--- a/src/test/regress/expected/plpgsql.out
+++ b/src/test/regress/expected/plpgsql.out
@@ -5026,6 +5026,7 @@ select scope_test();
drop function scope_test();
-- Check that variables are reinitialized on block re-entry.
+\set VERBOSITY terse \\ -- needed for output stability
do $$
begin
for i in 1..3 loop
@@ -5050,8 +5051,7 @@ NOTICE: r = (1,2)
NOTICE: x = <NULL>
NOTICE: y = 2
ERROR: record "r" is not assigned yet
-DETAIL: The tuple structure of a not-yet-assigned record is indeterminate.
-CONTEXT: PL/pgSQL function inline_code_block line 15 at RAISE
+\set VERBOSITY default
-- Check handling of conflicts between plpgsql vars and table columns.
set plpgsql.variable_conflict = error;
create function conflict_test() returns setof int8_tbl as $$
diff --git a/src/test/regress/sql/plpgsql.sql b/src/test/regress/sql/plpgsql.sql
index 07b6fc89716..bb09b2d8071 100644
--- a/src/test/regress/sql/plpgsql.sql
+++ b/src/test/regress/sql/plpgsql.sql
@@ -4016,6 +4016,7 @@ drop function scope_test();
-- Check that variables are reinitialized on block re-entry.
+\set VERBOSITY terse \\ -- needed for output stability
do $$
begin
for i in 1..3 loop
@@ -4034,6 +4035,7 @@ begin
end;
end loop;
end$$;
+\set VERBOSITY default
-- Check handling of conflicts between plpgsql vars and table columns.