regression.diffs

text/plain

Filename: regression.diffs
Type: text/plain
Part: 0
Message: Re: Schema variables - new implementation for Postgres 15
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;