regression.diffs
text/plain
Filename: regression.diffs
Type: text/plain
Part: 0
diff -U3 /home/aardvark/pg_stuff/pg_sandbox/pgsql.hide_column/contrib/test_decoding/expected/ddl.out /home/aardvark/pg_stuff/pg_sandbox/pgsql.hide_column/contrib/test_decoding/results/ddl.out
--- /home/aardvark/pg_stuff/pg_sandbox/pgsql.hide_column/contrib/test_decoding/expected/ddl.out 2021-10-27 22:50:11.953480787 +0200
+++ /home/aardvark/pg_stuff/pg_sandbox/pgsql.hide_column/contrib/test_decoding/results/ddl.out 2021-10-28 00:50:05.019304167 +0200
@@ -438,12 +438,12 @@
WITH (user_catalog_table = true)
;
\d+ replication_metadata
- Table "public.replication_metadata"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-----------+---------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | |
- relation | name | | not null | | plain | |
- options | text[] | | | | extended | |
+ Table "public.replication_metadata"
+ Column | Type | Collation | Nullable | Default | Expanded | Storage | Stats target | Description
+----------+---------+-----------+----------+--------------------------------------------------+----------+----------+--------------+-------------
+ id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | | plain | |
+ relation | name | | not null | | | plain | |
+ options | text[] | | | | | extended | |
Indexes:
"replication_metadata_pkey" PRIMARY KEY, btree (id)
Options: user_catalog_table=true
@@ -452,12 +452,12 @@
VALUES ('foo', ARRAY['a', 'b']);
ALTER TABLE replication_metadata RESET (user_catalog_table);
\d+ replication_metadata
- Table "public.replication_metadata"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-----------+---------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | |
- relation | name | | not null | | plain | |
- options | text[] | | | | extended | |
+ Table "public.replication_metadata"
+ Column | Type | Collation | Nullable | Default | Expanded | Storage | Stats target | Description
+----------+---------+-----------+----------+--------------------------------------------------+----------+----------+--------------+-------------
+ id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | | plain | |
+ relation | name | | not null | | | plain | |
+ options | text[] | | | | | extended | |
Indexes:
"replication_metadata_pkey" PRIMARY KEY, btree (id)
@@ -465,12 +465,12 @@
VALUES ('bar', ARRAY['a', 'b']);
ALTER TABLE replication_metadata SET (user_catalog_table = true);
\d+ replication_metadata
- Table "public.replication_metadata"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-----------+---------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | |
- relation | name | | not null | | plain | |
- options | text[] | | | | extended | |
+ Table "public.replication_metadata"
+ Column | Type | Collation | Nullable | Default | Expanded | Storage | Stats target | Description
+----------+---------+-----------+----------+--------------------------------------------------+----------+----------+--------------+-------------
+ id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | | plain | |
+ relation | name | | not null | | | plain | |
+ options | text[] | | | | | extended | |
Indexes:
"replication_metadata_pkey" PRIMARY KEY, btree (id)
Options: user_catalog_table=true
@@ -483,13 +483,13 @@
ERROR: cannot rewrite table "replication_metadata" used as a catalog table
ALTER TABLE replication_metadata SET (user_catalog_table = false);
\d+ replication_metadata
- Table "public.replication_metadata"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-----------------+---------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | |
- relation | name | | not null | | plain | |
- options | text[] | | | | extended | |
- rewritemeornot | integer | | | | plain | |
+ Table "public.replication_metadata"
+ Column | Type | Collation | Nullable | Default | Expanded | Storage | Stats target | Description
+----------------+---------+-----------+----------+--------------------------------------------------+----------+----------+--------------+-------------
+ id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | | plain | |
+ relation | name | | not null | | | plain | |
+ options | text[] | | | | | extended | |
+ rewritemeornot | integer | | | | | plain | |
Indexes:
"replication_metadata_pkey" PRIMARY KEY, btree (id)
Options: user_catalog_table=false