Op 27-10-2021 om 18:02 schreef Gilles Darold:
Otherwise, build, make check, chekc-world are OK. Also the pdf builds
ok.
Thanks Erik, new version v6 attached.
Hi,
Anther small thing: the test_decoding module was overlooked, I think.
Below is output from make check-world (this error does not occur in master)
Erik
============== running regression test queries ==============
test ddl ... FAILED 1210 ms
test xact ... ok 22 ms
test rewrite ... ok 176 ms
test toast ... ok 292 ms
test permissions ... ok 24 ms
test decoding_in_xact ... ok 23 ms
test decoding_into_rel ... ok 33 ms
test binary ... ok 16 ms
test prepared ... ok 21 ms
test replorigin ... ok 23 ms
test time ... ok 22 ms
test messages ... ok 26 ms
test spill ... ok 2407 ms
test slot ... ok 424 ms
test truncate ... ok 21 ms
test stream ... ok 31 ms
test stats ... ok 1097 ms
test twophase ... ok 46 ms
test twophase_stream ... ok 28 ms
============== shutting down postmaster ==============
=======================
1 of 19 tests failed.
=======================
The differences that caused some tests to fail can be viewed in the
file
"/home/aardvark/pg_stuff/pg_sandbox/pgsql.hide_column/contrib/test_decoding/regression.diffs".
A copy of the test summary that you see
above is saved in the file
"/home/aardvark/pg_stuff/pg_sandbox/pgsql.hide_column/contrib/test_decoding/regression.out".
../../src/makefiles/pgxs.mk:451: recipe for target 'check' failed
make[2]: *** [check] Error 1
make[2]: Leaving directory
'/home/aardvark/pg_stuff/pg_sandbox/pgsql.hide_column/contrib/test_decoding'
Makefile:94: recipe for target 'check-test_decoding-recurse' failed
make[1]: *** [check-test_decoding-recurse] Error 2
make[1]: Leaving directory
'/home/aardvark/pg_stuff/pg_sandbox/pgsql.hide_column/contrib'
GNUmakefile:71: recipe for target 'check-world-contrib-recurse' failed
make: *** [check-world-contrib-recurse] Error 2
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
