diff -U3 /home/aardvark/pg_stuff/pg_sandbox/pgsql.schema_variables/src/test/regress/expected/session_variables.out /home/aardvark/pg_stuff/pg_sandbox/pgsql.schema_variables/src/test/regress/results/session_variables.out --- /home/aardvark/pg_stuff/pg_sandbox/pgsql.schema_variables/src/test/regress/expected/session_variables.out 2021-12-19 07:48:40.422821574 +0100 +++ /home/aardvark/pg_stuff/pg_sandbox/pgsql.schema_variables/src/test/regress/results/session_variables.out 2021-12-19 08:00:29.286820957 +0100 @@ -32,11 +32,11 @@ SET ROLE TO DEFAULT; -- check output \dV+ var1 - List of variables - Schema | Name | Type | Is nullable | Is mutable | Default | Owner | Transactional end action | Access privileges | Description -----------+------+---------+-------------+------------+---------+-------+--------------------------+------------------------+------------- - svartest | var1 | numeric | t | t | | pavel | | pavel=SW/pavel +| - | | | | | | | | var_test_role=SW/pavel | + List of variables + Schema | Name | Type | Is nullable | Is mutable | Default | Owner | Transactional end action | Access privileges | Description +----------+------+---------+-------------+------------+---------+----------+--------------------------+---------------------------+------------- + svartest | var1 | numeric | t | t | | aardvark | | aardvark=SW/aardvark +| + | | | | | | | | var_test_role=SW/aardvark | (1 row) REVOKE ALL ON VARIABLE var1 FROM var_test_role; @@ -745,10 +745,10 @@ CREATE VARIABLE var1 AS int DEFAULT 100; COMMENT ON VARIABLE var1 IS 'some variable comment'; \dV+ var1 - List of variables - Schema | Name | Type | Is nullable | Is mutable | Default | Owner | Transactional end action | Access privileges | Description -----------+------+---------+-------------+------------+---------+-------+--------------------------+-------------------+----------------------- - svartest | var1 | integer | t | t | 100 | pavel | | | some variable comment + List of variables + Schema | Name | Type | Is nullable | Is mutable | Default | Owner | Transactional end action | Access privileges | Description +----------+------+---------+-------------+------------+---------+----------+--------------------------+-------------------+----------------------- + svartest | var1 | integer | t | t | 100 | aardvark | | | some variable comment (1 row) DROP VARIABLE var1;