From 443ff51e47cf2bb63c78c69e3e0473bcca7ff42f Mon Sep 17 00:00:00 2001 From: Craig Ringer Date: Mon, 7 Dec 2015 10:28:35 +0800 Subject: [PATCH] Logical decoding for sequence advances Add a new logical decoding callback seq_advance_cb that's invoked whenever we decode a new sequence chunk allocation from WAL. Also add support for it in test_decoding. It's guaranteed that the last_value passed to the callback is equal to or greater than (for +ve sequences) any value returned by a nextval() call visible to any transaction committed at or before the callback is invoked. In practice it'll be quite a lot larger because PostgreSQL preallocates large chunks of sequences to minimise WAL writes, at the cost of wasting values if it has to do crash recovery. Logical decoding sees the crash recovery position when it gets advanced. Needed to make logical replication based failover possible. --- contrib/test_decoding/expected/ddl.out | 2728 +++++++++++++++++++- .../test_decoding/expected/decoding_in_xact.out | 10 +- .../test_decoding/expected/decoding_into_rel.out | 45 +- contrib/test_decoding/expected/mxact.out | 2 + contrib/test_decoding/expected/ondisk_startup.out | 2 + contrib/test_decoding/expected/replorigin.out | 23 +- contrib/test_decoding/expected/rewrite.out | 10 +- contrib/test_decoding/expected/toast.out | 10 +- contrib/test_decoding/test_decoding.c | 16 + src/backend/replication/logical/decode.c | 60 +- src/backend/replication/logical/logical.c | 28 +- src/include/replication/logical.h | 3 + src/include/replication/output_plugin.h | 16 + 13 files changed, 2911 insertions(+), 42 deletions(-) diff --git a/contrib/test_decoding/expected/ddl.out b/contrib/test_decoding/expected/ddl.out index 57a1289..493fca0 100644 --- a/contrib/test_decoding/expected/ddl.out +++ b/contrib/test_decoding/expected/ddl.out @@ -92,6 +92,9 @@ INSERT INTO replication_example(somedata, somenum) VALUES (4, 1); SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data --------------------------------------------------------------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 BEGIN table public.replication_example: INSERT: id[integer]:1 somedata[integer]:1 text[character varying]:'1' table public.replication_example: INSERT: id[integer]:2 somedata[integer]:1 text[character varying]:'2' @@ -114,14 +117,14 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc BEGIN table public.replication_example: INSERT: id[integer]:10 somedata[integer]:4 somenum[character varying]:'1' COMMIT -(22 rows) +(25 rows) ALTER TABLE replication_example ALTER COLUMN somenum TYPE int4 USING (somenum::int4); -- throw away changes, they contain oids SELECT count(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); count ------- - 12 + 15 (1 row) INSERT INTO replication_example(somedata, somenum) VALUES (5, 1); @@ -137,6 +140,9 @@ COMMIT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ------------------------------------------------------------------------------------------------------------------------------------------ + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 BEGIN table public.replication_example: INSERT: id[integer]:11 somedata[integer]:5 somenum[integer]:1 COMMIT @@ -146,7 +152,7 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc table public.replication_example: INSERT: id[integer]:14 somedata[integer]:6 somenum[integer]:3 zaphod1[integer]:null zaphod2[integer]:1 table public.replication_example: INSERT: id[integer]:15 somedata[integer]:6 somenum[integer]:4 zaphod1[integer]:2 zaphod2[integer]:null COMMIT -(9 rows) +(12 rows) -- ON CONFLICT DO UPDATE support BEGIN; @@ -157,6 +163,9 @@ COMMIT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data -------------------------------------------------------------------------------------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 BEGIN table public.replication_example: INSERT: id[integer]:-15 somedata[integer]:-15 somenum[integer]:-15 zaphod1[integer]:null zaphod2[integer]:null table public.replication_example: INSERT: id[integer]:-14 somedata[integer]:-14 somenum[integer]:-14 zaphod1[integer]:null zaphod2[integer]:null @@ -190,7 +199,7 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc table public.replication_example: UPDATE: id[integer]:14 somedata[integer]:6 somenum[integer]:15 zaphod1[integer]:null zaphod2[integer]:1 table public.replication_example: UPDATE: id[integer]:15 somedata[integer]:6 somenum[integer]:16 zaphod1[integer]:2 zaphod2[integer]:null COMMIT -(33 rows) +(36 rows) -- hide changes bc of oid visible in full table rewrites CREATE TABLE tr_unique(id2 serial unique NOT NULL, data int); @@ -200,7 +209,7 @@ ALTER TABLE tr_pkey ADD COLUMN id serial primary key; SELECT count(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); count ------- - 6 + 15 (1 row) INSERT INTO tr_pkey(data) VALUES(1); @@ -210,6 +219,15 @@ DELETE FROM tr_pkey; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ---------------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 BEGIN table public.tr_pkey: INSERT: id2[integer]:2 data[integer]:1 id[integer]:2 COMMIT @@ -217,7 +235,7 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc table public.tr_pkey: DELETE: id[integer]:1 table public.tr_pkey: DELETE: id[integer]:2 COMMIT -(7 rows) +(16 rows) /* * check that disk spooling works @@ -233,12 +251,16 @@ SELECT count(*), min(data), max(data) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1') GROUP BY substring(data, 1, 24) ORDER BY 1,2; - count | min | max --------+-------------------------------------------------+------------------------------------------------------------------------ - 1 | BEGIN | BEGIN - 1 | COMMIT | COMMIT - 20467 | table public.tr_etoomuch: DELETE: id[integer]:1 | table public.tr_etoomuch: UPDATE: id[integer]:9999 data[integer]:-9999 -(3 rows) + count | min | max +-------+---------------------------------------------------+------------------------------------------------------------------------ + 1 | BEGIN | BEGIN + 1 | COMMIT | COMMIT + 3 | sequence replication_example_id_seq advanced to 1 | sequence replication_example_id_seq advanced to 33 + 3 | sequence tr_pkey_id_seq advanced to 1 | sequence tr_pkey_id_seq advanced to 33 + 3 | sequence tr_unique_id2_seq advanced to 1 | sequence tr_unique_id2_seq advanced to 33 + 313 | sequence tr_etoomuch_id_seq advanced to 1 | sequence tr_etoomuch_id_seq advanced to 9999 + 20467 | table public.tr_etoomuch: DELETE: id[integer]:1 | table public.tr_etoomuch: UPDATE: id[integer]:9999 data[integer]:-9999 +(7 rows) -- check that a large, spooled, upsert works INSERT INTO tr_etoomuch (id, data) @@ -250,11 +272,15 @@ GROUP BY 1 ORDER BY min(location - '0/0'); substring | count -------------------------------+------- - BEGIN | 1 + sequence tr_etoomuch_id_seq a | 313 + sequence replication_example_ | 3 + sequence tr_pkey_id_seq advan | 3 + sequence tr_unique_id2_seq ad | 3 table public.tr_etoomuch: UPD | 2235 + BEGIN | 1 table public.tr_etoomuch: INS | 1766 COMMIT | 1 -(4 rows) +(8 rows) /* * check whether we decode subtransactions correctly in relation with each @@ -279,6 +305,331 @@ COMMIT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ---------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 33 + sequence tr_etoomuch_id_seq advanced to 66 + sequence tr_etoomuch_id_seq advanced to 99 + sequence tr_etoomuch_id_seq advanced to 132 + sequence tr_etoomuch_id_seq advanced to 165 + sequence tr_etoomuch_id_seq advanced to 198 + sequence tr_etoomuch_id_seq advanced to 231 + sequence tr_etoomuch_id_seq advanced to 264 + sequence tr_etoomuch_id_seq advanced to 297 + sequence tr_etoomuch_id_seq advanced to 330 + sequence tr_etoomuch_id_seq advanced to 363 + sequence tr_etoomuch_id_seq advanced to 396 + sequence tr_etoomuch_id_seq advanced to 429 + sequence tr_etoomuch_id_seq advanced to 462 + sequence tr_etoomuch_id_seq advanced to 495 + sequence tr_etoomuch_id_seq advanced to 528 + sequence tr_etoomuch_id_seq advanced to 561 + sequence tr_etoomuch_id_seq advanced to 594 + sequence tr_etoomuch_id_seq advanced to 627 + sequence tr_etoomuch_id_seq advanced to 660 + sequence tr_etoomuch_id_seq advanced to 693 + sequence tr_etoomuch_id_seq advanced to 726 + sequence tr_etoomuch_id_seq advanced to 759 + sequence tr_etoomuch_id_seq advanced to 792 + sequence tr_etoomuch_id_seq advanced to 825 + sequence tr_etoomuch_id_seq advanced to 858 + sequence tr_etoomuch_id_seq advanced to 891 + sequence tr_etoomuch_id_seq advanced to 924 + sequence tr_etoomuch_id_seq advanced to 957 + sequence tr_etoomuch_id_seq advanced to 990 + sequence tr_etoomuch_id_seq advanced to 1023 + sequence tr_etoomuch_id_seq advanced to 1056 + sequence tr_etoomuch_id_seq advanced to 1089 + sequence tr_etoomuch_id_seq advanced to 1122 + sequence tr_etoomuch_id_seq advanced to 1155 + sequence tr_etoomuch_id_seq advanced to 1188 + sequence tr_etoomuch_id_seq advanced to 1221 + sequence tr_etoomuch_id_seq advanced to 1254 + sequence tr_etoomuch_id_seq advanced to 1287 + sequence tr_etoomuch_id_seq advanced to 1320 + sequence tr_etoomuch_id_seq advanced to 1353 + sequence tr_etoomuch_id_seq advanced to 1386 + sequence tr_etoomuch_id_seq advanced to 1419 + sequence tr_etoomuch_id_seq advanced to 1452 + sequence tr_etoomuch_id_seq advanced to 1485 + sequence tr_etoomuch_id_seq advanced to 1518 + sequence tr_etoomuch_id_seq advanced to 1551 + sequence tr_etoomuch_id_seq advanced to 1584 + sequence tr_etoomuch_id_seq advanced to 1617 + sequence tr_etoomuch_id_seq advanced to 1650 + sequence tr_etoomuch_id_seq advanced to 1683 + sequence tr_etoomuch_id_seq advanced to 1716 + sequence tr_etoomuch_id_seq advanced to 1749 + sequence tr_etoomuch_id_seq advanced to 1782 + sequence tr_etoomuch_id_seq advanced to 1815 + sequence tr_etoomuch_id_seq advanced to 1848 + sequence tr_etoomuch_id_seq advanced to 1881 + sequence tr_etoomuch_id_seq advanced to 1914 + sequence tr_etoomuch_id_seq advanced to 1947 + sequence tr_etoomuch_id_seq advanced to 1980 + sequence tr_etoomuch_id_seq advanced to 2013 + sequence tr_etoomuch_id_seq advanced to 2046 + sequence tr_etoomuch_id_seq advanced to 2079 + sequence tr_etoomuch_id_seq advanced to 2112 + sequence tr_etoomuch_id_seq advanced to 2145 + sequence tr_etoomuch_id_seq advanced to 2178 + sequence tr_etoomuch_id_seq advanced to 2211 + sequence tr_etoomuch_id_seq advanced to 2244 + sequence tr_etoomuch_id_seq advanced to 2277 + sequence tr_etoomuch_id_seq advanced to 2310 + sequence tr_etoomuch_id_seq advanced to 2343 + sequence tr_etoomuch_id_seq advanced to 2376 + sequence tr_etoomuch_id_seq advanced to 2409 + sequence tr_etoomuch_id_seq advanced to 2442 + sequence tr_etoomuch_id_seq advanced to 2475 + sequence tr_etoomuch_id_seq advanced to 2508 + sequence tr_etoomuch_id_seq advanced to 2541 + sequence tr_etoomuch_id_seq advanced to 2574 + sequence tr_etoomuch_id_seq advanced to 2607 + sequence tr_etoomuch_id_seq advanced to 2640 + sequence tr_etoomuch_id_seq advanced to 2673 + sequence tr_etoomuch_id_seq advanced to 2706 + sequence tr_etoomuch_id_seq advanced to 2739 + sequence tr_etoomuch_id_seq advanced to 2772 + sequence tr_etoomuch_id_seq advanced to 2805 + sequence tr_etoomuch_id_seq advanced to 2838 + sequence tr_etoomuch_id_seq advanced to 2871 + sequence tr_etoomuch_id_seq advanced to 2904 + sequence tr_etoomuch_id_seq advanced to 2937 + sequence tr_etoomuch_id_seq advanced to 2970 + sequence tr_etoomuch_id_seq advanced to 3003 + sequence tr_etoomuch_id_seq advanced to 3036 + sequence tr_etoomuch_id_seq advanced to 3069 + sequence tr_etoomuch_id_seq advanced to 3102 + sequence tr_etoomuch_id_seq advanced to 3135 + sequence tr_etoomuch_id_seq advanced to 3168 + sequence tr_etoomuch_id_seq advanced to 3201 + sequence tr_etoomuch_id_seq advanced to 3234 + sequence tr_etoomuch_id_seq advanced to 3267 + sequence tr_etoomuch_id_seq advanced to 3300 + sequence tr_etoomuch_id_seq advanced to 3333 + sequence tr_etoomuch_id_seq advanced to 3366 + sequence tr_etoomuch_id_seq advanced to 3399 + sequence tr_etoomuch_id_seq advanced to 3432 + sequence tr_etoomuch_id_seq advanced to 3465 + sequence tr_etoomuch_id_seq advanced to 3498 + sequence tr_etoomuch_id_seq advanced to 3531 + sequence tr_etoomuch_id_seq advanced to 3564 + sequence tr_etoomuch_id_seq advanced to 3597 + sequence tr_etoomuch_id_seq advanced to 3630 + sequence tr_etoomuch_id_seq advanced to 3663 + sequence tr_etoomuch_id_seq advanced to 3696 + sequence tr_etoomuch_id_seq advanced to 3729 + sequence tr_etoomuch_id_seq advanced to 3762 + sequence tr_etoomuch_id_seq advanced to 3795 + sequence tr_etoomuch_id_seq advanced to 3828 + sequence tr_etoomuch_id_seq advanced to 3861 + sequence tr_etoomuch_id_seq advanced to 3894 + sequence tr_etoomuch_id_seq advanced to 3927 + sequence tr_etoomuch_id_seq advanced to 3960 + sequence tr_etoomuch_id_seq advanced to 3993 + sequence tr_etoomuch_id_seq advanced to 4026 + sequence tr_etoomuch_id_seq advanced to 4059 + sequence tr_etoomuch_id_seq advanced to 4092 + sequence tr_etoomuch_id_seq advanced to 4125 + sequence tr_etoomuch_id_seq advanced to 4158 + sequence tr_etoomuch_id_seq advanced to 4191 + sequence tr_etoomuch_id_seq advanced to 4224 + sequence tr_etoomuch_id_seq advanced to 4257 + sequence tr_etoomuch_id_seq advanced to 4290 + sequence tr_etoomuch_id_seq advanced to 4323 + sequence tr_etoomuch_id_seq advanced to 4356 + sequence tr_etoomuch_id_seq advanced to 4389 + sequence tr_etoomuch_id_seq advanced to 4422 + sequence tr_etoomuch_id_seq advanced to 4455 + sequence tr_etoomuch_id_seq advanced to 4488 + sequence tr_etoomuch_id_seq advanced to 4521 + sequence tr_etoomuch_id_seq advanced to 4554 + sequence tr_etoomuch_id_seq advanced to 4587 + sequence tr_etoomuch_id_seq advanced to 4620 + sequence tr_etoomuch_id_seq advanced to 4653 + sequence tr_etoomuch_id_seq advanced to 4686 + sequence tr_etoomuch_id_seq advanced to 4719 + sequence tr_etoomuch_id_seq advanced to 4752 + sequence tr_etoomuch_id_seq advanced to 4785 + sequence tr_etoomuch_id_seq advanced to 4818 + sequence tr_etoomuch_id_seq advanced to 4851 + sequence tr_etoomuch_id_seq advanced to 4884 + sequence tr_etoomuch_id_seq advanced to 4917 + sequence tr_etoomuch_id_seq advanced to 4950 + sequence tr_etoomuch_id_seq advanced to 4983 + sequence tr_etoomuch_id_seq advanced to 5016 + sequence tr_etoomuch_id_seq advanced to 5049 + sequence tr_etoomuch_id_seq advanced to 5082 + sequence tr_etoomuch_id_seq advanced to 5115 + sequence tr_etoomuch_id_seq advanced to 5148 + sequence tr_etoomuch_id_seq advanced to 5181 + sequence tr_etoomuch_id_seq advanced to 5214 + sequence tr_etoomuch_id_seq advanced to 5247 + sequence tr_etoomuch_id_seq advanced to 5280 + sequence tr_etoomuch_id_seq advanced to 5313 + sequence tr_etoomuch_id_seq advanced to 5346 + sequence tr_etoomuch_id_seq advanced to 5379 + sequence tr_etoomuch_id_seq advanced to 5412 + sequence tr_etoomuch_id_seq advanced to 5445 + sequence tr_etoomuch_id_seq advanced to 5478 + sequence tr_etoomuch_id_seq advanced to 5511 + sequence tr_etoomuch_id_seq advanced to 5544 + sequence tr_etoomuch_id_seq advanced to 5577 + sequence tr_etoomuch_id_seq advanced to 5610 + sequence tr_etoomuch_id_seq advanced to 5643 + sequence tr_etoomuch_id_seq advanced to 5676 + sequence tr_etoomuch_id_seq advanced to 5709 + sequence tr_etoomuch_id_seq advanced to 5742 + sequence tr_etoomuch_id_seq advanced to 5775 + sequence tr_etoomuch_id_seq advanced to 5808 + sequence tr_etoomuch_id_seq advanced to 5841 + sequence tr_etoomuch_id_seq advanced to 5874 + sequence tr_etoomuch_id_seq advanced to 5907 + sequence tr_etoomuch_id_seq advanced to 5940 + sequence tr_etoomuch_id_seq advanced to 5973 + sequence tr_etoomuch_id_seq advanced to 6006 + sequence tr_etoomuch_id_seq advanced to 6039 + sequence tr_etoomuch_id_seq advanced to 6072 + sequence tr_etoomuch_id_seq advanced to 6105 + sequence tr_etoomuch_id_seq advanced to 6138 + sequence tr_etoomuch_id_seq advanced to 6171 + sequence tr_etoomuch_id_seq advanced to 6204 + sequence tr_etoomuch_id_seq advanced to 6237 + sequence tr_etoomuch_id_seq advanced to 6270 + sequence tr_etoomuch_id_seq advanced to 6303 + sequence tr_etoomuch_id_seq advanced to 6336 + sequence tr_etoomuch_id_seq advanced to 6369 + sequence tr_etoomuch_id_seq advanced to 6402 + sequence tr_etoomuch_id_seq advanced to 6435 + sequence tr_etoomuch_id_seq advanced to 6468 + sequence tr_etoomuch_id_seq advanced to 6501 + sequence tr_etoomuch_id_seq advanced to 6534 + sequence tr_etoomuch_id_seq advanced to 6567 + sequence tr_etoomuch_id_seq advanced to 6600 + sequence tr_etoomuch_id_seq advanced to 6633 + sequence tr_etoomuch_id_seq advanced to 6666 + sequence tr_etoomuch_id_seq advanced to 6699 + sequence tr_etoomuch_id_seq advanced to 6732 + sequence tr_etoomuch_id_seq advanced to 6765 + sequence tr_etoomuch_id_seq advanced to 6798 + sequence tr_etoomuch_id_seq advanced to 6831 + sequence tr_etoomuch_id_seq advanced to 6864 + sequence tr_etoomuch_id_seq advanced to 6897 + sequence tr_etoomuch_id_seq advanced to 6930 + sequence tr_etoomuch_id_seq advanced to 6963 + sequence tr_etoomuch_id_seq advanced to 6996 + sequence tr_etoomuch_id_seq advanced to 7029 + sequence tr_etoomuch_id_seq advanced to 7062 + sequence tr_etoomuch_id_seq advanced to 7095 + sequence tr_etoomuch_id_seq advanced to 7128 + sequence tr_etoomuch_id_seq advanced to 7161 + sequence tr_etoomuch_id_seq advanced to 7194 + sequence tr_etoomuch_id_seq advanced to 7227 + sequence tr_etoomuch_id_seq advanced to 7260 + sequence tr_etoomuch_id_seq advanced to 7293 + sequence tr_etoomuch_id_seq advanced to 7326 + sequence tr_etoomuch_id_seq advanced to 7359 + sequence tr_etoomuch_id_seq advanced to 7392 + sequence tr_etoomuch_id_seq advanced to 7425 + sequence tr_etoomuch_id_seq advanced to 7458 + sequence tr_etoomuch_id_seq advanced to 7491 + sequence tr_etoomuch_id_seq advanced to 7524 + sequence tr_etoomuch_id_seq advanced to 7557 + sequence tr_etoomuch_id_seq advanced to 7590 + sequence tr_etoomuch_id_seq advanced to 7623 + sequence tr_etoomuch_id_seq advanced to 7656 + sequence tr_etoomuch_id_seq advanced to 7689 + sequence tr_etoomuch_id_seq advanced to 7722 + sequence tr_etoomuch_id_seq advanced to 7755 + sequence tr_etoomuch_id_seq advanced to 7788 + sequence tr_etoomuch_id_seq advanced to 7821 + sequence tr_etoomuch_id_seq advanced to 7854 + sequence tr_etoomuch_id_seq advanced to 7887 + sequence tr_etoomuch_id_seq advanced to 7920 + sequence tr_etoomuch_id_seq advanced to 7953 + sequence tr_etoomuch_id_seq advanced to 7986 + sequence tr_etoomuch_id_seq advanced to 8019 + sequence tr_etoomuch_id_seq advanced to 8052 + sequence tr_etoomuch_id_seq advanced to 8085 + sequence tr_etoomuch_id_seq advanced to 8118 + sequence tr_etoomuch_id_seq advanced to 8151 + sequence tr_etoomuch_id_seq advanced to 8184 + sequence tr_etoomuch_id_seq advanced to 8217 + sequence tr_etoomuch_id_seq advanced to 8250 + sequence tr_etoomuch_id_seq advanced to 8283 + sequence tr_etoomuch_id_seq advanced to 8316 + sequence tr_etoomuch_id_seq advanced to 8349 + sequence tr_etoomuch_id_seq advanced to 8382 + sequence tr_etoomuch_id_seq advanced to 8415 + sequence tr_etoomuch_id_seq advanced to 8448 + sequence tr_etoomuch_id_seq advanced to 8481 + sequence tr_etoomuch_id_seq advanced to 8514 + sequence tr_etoomuch_id_seq advanced to 8547 + sequence tr_etoomuch_id_seq advanced to 8580 + sequence tr_etoomuch_id_seq advanced to 8613 + sequence tr_etoomuch_id_seq advanced to 8646 + sequence tr_etoomuch_id_seq advanced to 8679 + sequence tr_etoomuch_id_seq advanced to 8712 + sequence tr_etoomuch_id_seq advanced to 8745 + sequence tr_etoomuch_id_seq advanced to 8778 + sequence tr_etoomuch_id_seq advanced to 8811 + sequence tr_etoomuch_id_seq advanced to 8844 + sequence tr_etoomuch_id_seq advanced to 8877 + sequence tr_etoomuch_id_seq advanced to 8910 + sequence tr_etoomuch_id_seq advanced to 8943 + sequence tr_etoomuch_id_seq advanced to 8976 + sequence tr_etoomuch_id_seq advanced to 9009 + sequence tr_etoomuch_id_seq advanced to 9042 + sequence tr_etoomuch_id_seq advanced to 9075 + sequence tr_etoomuch_id_seq advanced to 9108 + sequence tr_etoomuch_id_seq advanced to 9141 + sequence tr_etoomuch_id_seq advanced to 9174 + sequence tr_etoomuch_id_seq advanced to 9207 + sequence tr_etoomuch_id_seq advanced to 9240 + sequence tr_etoomuch_id_seq advanced to 9273 + sequence tr_etoomuch_id_seq advanced to 9306 + sequence tr_etoomuch_id_seq advanced to 9339 + sequence tr_etoomuch_id_seq advanced to 9372 + sequence tr_etoomuch_id_seq advanced to 9405 + sequence tr_etoomuch_id_seq advanced to 9438 + sequence tr_etoomuch_id_seq advanced to 9471 + sequence tr_etoomuch_id_seq advanced to 9504 + sequence tr_etoomuch_id_seq advanced to 9537 + sequence tr_etoomuch_id_seq advanced to 9570 + sequence tr_etoomuch_id_seq advanced to 9603 + sequence tr_etoomuch_id_seq advanced to 9636 + sequence tr_etoomuch_id_seq advanced to 9669 + sequence tr_etoomuch_id_seq advanced to 9702 + sequence tr_etoomuch_id_seq advanced to 9735 + sequence tr_etoomuch_id_seq advanced to 9768 + sequence tr_etoomuch_id_seq advanced to 9801 + sequence tr_etoomuch_id_seq advanced to 9834 + sequence tr_etoomuch_id_seq advanced to 9867 + sequence tr_etoomuch_id_seq advanced to 9900 + sequence tr_etoomuch_id_seq advanced to 9933 + sequence tr_etoomuch_id_seq advanced to 9966 + sequence tr_etoomuch_id_seq advanced to 9999 + sequence tr_etoomuch_id_seq advanced to 10032 + sequence tr_etoomuch_id_seq advanced to 10065 + sequence tr_etoomuch_id_seq advanced to 10098 + sequence tr_etoomuch_id_seq advanced to 10131 + sequence tr_etoomuch_id_seq advanced to 10164 + sequence tr_etoomuch_id_seq advanced to 10197 + sequence tr_etoomuch_id_seq advanced to 10230 + sequence tr_etoomuch_id_seq advanced to 10263 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 33 BEGIN table public.tr_sub: INSERT: id[integer]:1 path[text]:'1-top-#1' table public.tr_sub: INSERT: id[integer]:2 path[text]:'1-top-1-#1' @@ -287,7 +638,7 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc table public.tr_sub: INSERT: id[integer]:5 path[text]:'1-top-2-1-#2' table public.tr_sub: INSERT: id[integer]:6 path[text]:'1-top-2-#1' COMMIT -(8 rows) +(333 rows) -- check that we handle xlog assignments correctly BEGIN; @@ -318,13 +669,338 @@ COMMIT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ------------------------------------------------------------------------ + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 33 + sequence tr_etoomuch_id_seq advanced to 66 + sequence tr_etoomuch_id_seq advanced to 99 + sequence tr_etoomuch_id_seq advanced to 132 + sequence tr_etoomuch_id_seq advanced to 165 + sequence tr_etoomuch_id_seq advanced to 198 + sequence tr_etoomuch_id_seq advanced to 231 + sequence tr_etoomuch_id_seq advanced to 264 + sequence tr_etoomuch_id_seq advanced to 297 + sequence tr_etoomuch_id_seq advanced to 330 + sequence tr_etoomuch_id_seq advanced to 363 + sequence tr_etoomuch_id_seq advanced to 396 + sequence tr_etoomuch_id_seq advanced to 429 + sequence tr_etoomuch_id_seq advanced to 462 + sequence tr_etoomuch_id_seq advanced to 495 + sequence tr_etoomuch_id_seq advanced to 528 + sequence tr_etoomuch_id_seq advanced to 561 + sequence tr_etoomuch_id_seq advanced to 594 + sequence tr_etoomuch_id_seq advanced to 627 + sequence tr_etoomuch_id_seq advanced to 660 + sequence tr_etoomuch_id_seq advanced to 693 + sequence tr_etoomuch_id_seq advanced to 726 + sequence tr_etoomuch_id_seq advanced to 759 + sequence tr_etoomuch_id_seq advanced to 792 + sequence tr_etoomuch_id_seq advanced to 825 + sequence tr_etoomuch_id_seq advanced to 858 + sequence tr_etoomuch_id_seq advanced to 891 + sequence tr_etoomuch_id_seq advanced to 924 + sequence tr_etoomuch_id_seq advanced to 957 + sequence tr_etoomuch_id_seq advanced to 990 + sequence tr_etoomuch_id_seq advanced to 1023 + sequence tr_etoomuch_id_seq advanced to 1056 + sequence tr_etoomuch_id_seq advanced to 1089 + sequence tr_etoomuch_id_seq advanced to 1122 + sequence tr_etoomuch_id_seq advanced to 1155 + sequence tr_etoomuch_id_seq advanced to 1188 + sequence tr_etoomuch_id_seq advanced to 1221 + sequence tr_etoomuch_id_seq advanced to 1254 + sequence tr_etoomuch_id_seq advanced to 1287 + sequence tr_etoomuch_id_seq advanced to 1320 + sequence tr_etoomuch_id_seq advanced to 1353 + sequence tr_etoomuch_id_seq advanced to 1386 + sequence tr_etoomuch_id_seq advanced to 1419 + sequence tr_etoomuch_id_seq advanced to 1452 + sequence tr_etoomuch_id_seq advanced to 1485 + sequence tr_etoomuch_id_seq advanced to 1518 + sequence tr_etoomuch_id_seq advanced to 1551 + sequence tr_etoomuch_id_seq advanced to 1584 + sequence tr_etoomuch_id_seq advanced to 1617 + sequence tr_etoomuch_id_seq advanced to 1650 + sequence tr_etoomuch_id_seq advanced to 1683 + sequence tr_etoomuch_id_seq advanced to 1716 + sequence tr_etoomuch_id_seq advanced to 1749 + sequence tr_etoomuch_id_seq advanced to 1782 + sequence tr_etoomuch_id_seq advanced to 1815 + sequence tr_etoomuch_id_seq advanced to 1848 + sequence tr_etoomuch_id_seq advanced to 1881 + sequence tr_etoomuch_id_seq advanced to 1914 + sequence tr_etoomuch_id_seq advanced to 1947 + sequence tr_etoomuch_id_seq advanced to 1980 + sequence tr_etoomuch_id_seq advanced to 2013 + sequence tr_etoomuch_id_seq advanced to 2046 + sequence tr_etoomuch_id_seq advanced to 2079 + sequence tr_etoomuch_id_seq advanced to 2112 + sequence tr_etoomuch_id_seq advanced to 2145 + sequence tr_etoomuch_id_seq advanced to 2178 + sequence tr_etoomuch_id_seq advanced to 2211 + sequence tr_etoomuch_id_seq advanced to 2244 + sequence tr_etoomuch_id_seq advanced to 2277 + sequence tr_etoomuch_id_seq advanced to 2310 + sequence tr_etoomuch_id_seq advanced to 2343 + sequence tr_etoomuch_id_seq advanced to 2376 + sequence tr_etoomuch_id_seq advanced to 2409 + sequence tr_etoomuch_id_seq advanced to 2442 + sequence tr_etoomuch_id_seq advanced to 2475 + sequence tr_etoomuch_id_seq advanced to 2508 + sequence tr_etoomuch_id_seq advanced to 2541 + sequence tr_etoomuch_id_seq advanced to 2574 + sequence tr_etoomuch_id_seq advanced to 2607 + sequence tr_etoomuch_id_seq advanced to 2640 + sequence tr_etoomuch_id_seq advanced to 2673 + sequence tr_etoomuch_id_seq advanced to 2706 + sequence tr_etoomuch_id_seq advanced to 2739 + sequence tr_etoomuch_id_seq advanced to 2772 + sequence tr_etoomuch_id_seq advanced to 2805 + sequence tr_etoomuch_id_seq advanced to 2838 + sequence tr_etoomuch_id_seq advanced to 2871 + sequence tr_etoomuch_id_seq advanced to 2904 + sequence tr_etoomuch_id_seq advanced to 2937 + sequence tr_etoomuch_id_seq advanced to 2970 + sequence tr_etoomuch_id_seq advanced to 3003 + sequence tr_etoomuch_id_seq advanced to 3036 + sequence tr_etoomuch_id_seq advanced to 3069 + sequence tr_etoomuch_id_seq advanced to 3102 + sequence tr_etoomuch_id_seq advanced to 3135 + sequence tr_etoomuch_id_seq advanced to 3168 + sequence tr_etoomuch_id_seq advanced to 3201 + sequence tr_etoomuch_id_seq advanced to 3234 + sequence tr_etoomuch_id_seq advanced to 3267 + sequence tr_etoomuch_id_seq advanced to 3300 + sequence tr_etoomuch_id_seq advanced to 3333 + sequence tr_etoomuch_id_seq advanced to 3366 + sequence tr_etoomuch_id_seq advanced to 3399 + sequence tr_etoomuch_id_seq advanced to 3432 + sequence tr_etoomuch_id_seq advanced to 3465 + sequence tr_etoomuch_id_seq advanced to 3498 + sequence tr_etoomuch_id_seq advanced to 3531 + sequence tr_etoomuch_id_seq advanced to 3564 + sequence tr_etoomuch_id_seq advanced to 3597 + sequence tr_etoomuch_id_seq advanced to 3630 + sequence tr_etoomuch_id_seq advanced to 3663 + sequence tr_etoomuch_id_seq advanced to 3696 + sequence tr_etoomuch_id_seq advanced to 3729 + sequence tr_etoomuch_id_seq advanced to 3762 + sequence tr_etoomuch_id_seq advanced to 3795 + sequence tr_etoomuch_id_seq advanced to 3828 + sequence tr_etoomuch_id_seq advanced to 3861 + sequence tr_etoomuch_id_seq advanced to 3894 + sequence tr_etoomuch_id_seq advanced to 3927 + sequence tr_etoomuch_id_seq advanced to 3960 + sequence tr_etoomuch_id_seq advanced to 3993 + sequence tr_etoomuch_id_seq advanced to 4026 + sequence tr_etoomuch_id_seq advanced to 4059 + sequence tr_etoomuch_id_seq advanced to 4092 + sequence tr_etoomuch_id_seq advanced to 4125 + sequence tr_etoomuch_id_seq advanced to 4158 + sequence tr_etoomuch_id_seq advanced to 4191 + sequence tr_etoomuch_id_seq advanced to 4224 + sequence tr_etoomuch_id_seq advanced to 4257 + sequence tr_etoomuch_id_seq advanced to 4290 + sequence tr_etoomuch_id_seq advanced to 4323 + sequence tr_etoomuch_id_seq advanced to 4356 + sequence tr_etoomuch_id_seq advanced to 4389 + sequence tr_etoomuch_id_seq advanced to 4422 + sequence tr_etoomuch_id_seq advanced to 4455 + sequence tr_etoomuch_id_seq advanced to 4488 + sequence tr_etoomuch_id_seq advanced to 4521 + sequence tr_etoomuch_id_seq advanced to 4554 + sequence tr_etoomuch_id_seq advanced to 4587 + sequence tr_etoomuch_id_seq advanced to 4620 + sequence tr_etoomuch_id_seq advanced to 4653 + sequence tr_etoomuch_id_seq advanced to 4686 + sequence tr_etoomuch_id_seq advanced to 4719 + sequence tr_etoomuch_id_seq advanced to 4752 + sequence tr_etoomuch_id_seq advanced to 4785 + sequence tr_etoomuch_id_seq advanced to 4818 + sequence tr_etoomuch_id_seq advanced to 4851 + sequence tr_etoomuch_id_seq advanced to 4884 + sequence tr_etoomuch_id_seq advanced to 4917 + sequence tr_etoomuch_id_seq advanced to 4950 + sequence tr_etoomuch_id_seq advanced to 4983 + sequence tr_etoomuch_id_seq advanced to 5016 + sequence tr_etoomuch_id_seq advanced to 5049 + sequence tr_etoomuch_id_seq advanced to 5082 + sequence tr_etoomuch_id_seq advanced to 5115 + sequence tr_etoomuch_id_seq advanced to 5148 + sequence tr_etoomuch_id_seq advanced to 5181 + sequence tr_etoomuch_id_seq advanced to 5214 + sequence tr_etoomuch_id_seq advanced to 5247 + sequence tr_etoomuch_id_seq advanced to 5280 + sequence tr_etoomuch_id_seq advanced to 5313 + sequence tr_etoomuch_id_seq advanced to 5346 + sequence tr_etoomuch_id_seq advanced to 5379 + sequence tr_etoomuch_id_seq advanced to 5412 + sequence tr_etoomuch_id_seq advanced to 5445 + sequence tr_etoomuch_id_seq advanced to 5478 + sequence tr_etoomuch_id_seq advanced to 5511 + sequence tr_etoomuch_id_seq advanced to 5544 + sequence tr_etoomuch_id_seq advanced to 5577 + sequence tr_etoomuch_id_seq advanced to 5610 + sequence tr_etoomuch_id_seq advanced to 5643 + sequence tr_etoomuch_id_seq advanced to 5676 + sequence tr_etoomuch_id_seq advanced to 5709 + sequence tr_etoomuch_id_seq advanced to 5742 + sequence tr_etoomuch_id_seq advanced to 5775 + sequence tr_etoomuch_id_seq advanced to 5808 + sequence tr_etoomuch_id_seq advanced to 5841 + sequence tr_etoomuch_id_seq advanced to 5874 + sequence tr_etoomuch_id_seq advanced to 5907 + sequence tr_etoomuch_id_seq advanced to 5940 + sequence tr_etoomuch_id_seq advanced to 5973 + sequence tr_etoomuch_id_seq advanced to 6006 + sequence tr_etoomuch_id_seq advanced to 6039 + sequence tr_etoomuch_id_seq advanced to 6072 + sequence tr_etoomuch_id_seq advanced to 6105 + sequence tr_etoomuch_id_seq advanced to 6138 + sequence tr_etoomuch_id_seq advanced to 6171 + sequence tr_etoomuch_id_seq advanced to 6204 + sequence tr_etoomuch_id_seq advanced to 6237 + sequence tr_etoomuch_id_seq advanced to 6270 + sequence tr_etoomuch_id_seq advanced to 6303 + sequence tr_etoomuch_id_seq advanced to 6336 + sequence tr_etoomuch_id_seq advanced to 6369 + sequence tr_etoomuch_id_seq advanced to 6402 + sequence tr_etoomuch_id_seq advanced to 6435 + sequence tr_etoomuch_id_seq advanced to 6468 + sequence tr_etoomuch_id_seq advanced to 6501 + sequence tr_etoomuch_id_seq advanced to 6534 + sequence tr_etoomuch_id_seq advanced to 6567 + sequence tr_etoomuch_id_seq advanced to 6600 + sequence tr_etoomuch_id_seq advanced to 6633 + sequence tr_etoomuch_id_seq advanced to 6666 + sequence tr_etoomuch_id_seq advanced to 6699 + sequence tr_etoomuch_id_seq advanced to 6732 + sequence tr_etoomuch_id_seq advanced to 6765 + sequence tr_etoomuch_id_seq advanced to 6798 + sequence tr_etoomuch_id_seq advanced to 6831 + sequence tr_etoomuch_id_seq advanced to 6864 + sequence tr_etoomuch_id_seq advanced to 6897 + sequence tr_etoomuch_id_seq advanced to 6930 + sequence tr_etoomuch_id_seq advanced to 6963 + sequence tr_etoomuch_id_seq advanced to 6996 + sequence tr_etoomuch_id_seq advanced to 7029 + sequence tr_etoomuch_id_seq advanced to 7062 + sequence tr_etoomuch_id_seq advanced to 7095 + sequence tr_etoomuch_id_seq advanced to 7128 + sequence tr_etoomuch_id_seq advanced to 7161 + sequence tr_etoomuch_id_seq advanced to 7194 + sequence tr_etoomuch_id_seq advanced to 7227 + sequence tr_etoomuch_id_seq advanced to 7260 + sequence tr_etoomuch_id_seq advanced to 7293 + sequence tr_etoomuch_id_seq advanced to 7326 + sequence tr_etoomuch_id_seq advanced to 7359 + sequence tr_etoomuch_id_seq advanced to 7392 + sequence tr_etoomuch_id_seq advanced to 7425 + sequence tr_etoomuch_id_seq advanced to 7458 + sequence tr_etoomuch_id_seq advanced to 7491 + sequence tr_etoomuch_id_seq advanced to 7524 + sequence tr_etoomuch_id_seq advanced to 7557 + sequence tr_etoomuch_id_seq advanced to 7590 + sequence tr_etoomuch_id_seq advanced to 7623 + sequence tr_etoomuch_id_seq advanced to 7656 + sequence tr_etoomuch_id_seq advanced to 7689 + sequence tr_etoomuch_id_seq advanced to 7722 + sequence tr_etoomuch_id_seq advanced to 7755 + sequence tr_etoomuch_id_seq advanced to 7788 + sequence tr_etoomuch_id_seq advanced to 7821 + sequence tr_etoomuch_id_seq advanced to 7854 + sequence tr_etoomuch_id_seq advanced to 7887 + sequence tr_etoomuch_id_seq advanced to 7920 + sequence tr_etoomuch_id_seq advanced to 7953 + sequence tr_etoomuch_id_seq advanced to 7986 + sequence tr_etoomuch_id_seq advanced to 8019 + sequence tr_etoomuch_id_seq advanced to 8052 + sequence tr_etoomuch_id_seq advanced to 8085 + sequence tr_etoomuch_id_seq advanced to 8118 + sequence tr_etoomuch_id_seq advanced to 8151 + sequence tr_etoomuch_id_seq advanced to 8184 + sequence tr_etoomuch_id_seq advanced to 8217 + sequence tr_etoomuch_id_seq advanced to 8250 + sequence tr_etoomuch_id_seq advanced to 8283 + sequence tr_etoomuch_id_seq advanced to 8316 + sequence tr_etoomuch_id_seq advanced to 8349 + sequence tr_etoomuch_id_seq advanced to 8382 + sequence tr_etoomuch_id_seq advanced to 8415 + sequence tr_etoomuch_id_seq advanced to 8448 + sequence tr_etoomuch_id_seq advanced to 8481 + sequence tr_etoomuch_id_seq advanced to 8514 + sequence tr_etoomuch_id_seq advanced to 8547 + sequence tr_etoomuch_id_seq advanced to 8580 + sequence tr_etoomuch_id_seq advanced to 8613 + sequence tr_etoomuch_id_seq advanced to 8646 + sequence tr_etoomuch_id_seq advanced to 8679 + sequence tr_etoomuch_id_seq advanced to 8712 + sequence tr_etoomuch_id_seq advanced to 8745 + sequence tr_etoomuch_id_seq advanced to 8778 + sequence tr_etoomuch_id_seq advanced to 8811 + sequence tr_etoomuch_id_seq advanced to 8844 + sequence tr_etoomuch_id_seq advanced to 8877 + sequence tr_etoomuch_id_seq advanced to 8910 + sequence tr_etoomuch_id_seq advanced to 8943 + sequence tr_etoomuch_id_seq advanced to 8976 + sequence tr_etoomuch_id_seq advanced to 9009 + sequence tr_etoomuch_id_seq advanced to 9042 + sequence tr_etoomuch_id_seq advanced to 9075 + sequence tr_etoomuch_id_seq advanced to 9108 + sequence tr_etoomuch_id_seq advanced to 9141 + sequence tr_etoomuch_id_seq advanced to 9174 + sequence tr_etoomuch_id_seq advanced to 9207 + sequence tr_etoomuch_id_seq advanced to 9240 + sequence tr_etoomuch_id_seq advanced to 9273 + sequence tr_etoomuch_id_seq advanced to 9306 + sequence tr_etoomuch_id_seq advanced to 9339 + sequence tr_etoomuch_id_seq advanced to 9372 + sequence tr_etoomuch_id_seq advanced to 9405 + sequence tr_etoomuch_id_seq advanced to 9438 + sequence tr_etoomuch_id_seq advanced to 9471 + sequence tr_etoomuch_id_seq advanced to 9504 + sequence tr_etoomuch_id_seq advanced to 9537 + sequence tr_etoomuch_id_seq advanced to 9570 + sequence tr_etoomuch_id_seq advanced to 9603 + sequence tr_etoomuch_id_seq advanced to 9636 + sequence tr_etoomuch_id_seq advanced to 9669 + sequence tr_etoomuch_id_seq advanced to 9702 + sequence tr_etoomuch_id_seq advanced to 9735 + sequence tr_etoomuch_id_seq advanced to 9768 + sequence tr_etoomuch_id_seq advanced to 9801 + sequence tr_etoomuch_id_seq advanced to 9834 + sequence tr_etoomuch_id_seq advanced to 9867 + sequence tr_etoomuch_id_seq advanced to 9900 + sequence tr_etoomuch_id_seq advanced to 9933 + sequence tr_etoomuch_id_seq advanced to 9966 + sequence tr_etoomuch_id_seq advanced to 9999 + sequence tr_etoomuch_id_seq advanced to 10032 + sequence tr_etoomuch_id_seq advanced to 10065 + sequence tr_etoomuch_id_seq advanced to 10098 + sequence tr_etoomuch_id_seq advanced to 10131 + sequence tr_etoomuch_id_seq advanced to 10164 + sequence tr_etoomuch_id_seq advanced to 10197 + sequence tr_etoomuch_id_seq advanced to 10230 + sequence tr_etoomuch_id_seq advanced to 10263 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 33 BEGIN table public.tr_sub: INSERT: id[integer]:7 path[text]:'2-top-1...--#1' table public.tr_sub: INSERT: id[integer]:8 path[text]:'2-top-1...--#2' table public.tr_sub: INSERT: id[integer]:9 path[text]:'2-top-1...--#3' table public.tr_sub: INSERT: id[integer]:10 path[text]:'2-top-#1' COMMIT -(6 rows) +(331 rows) -- make sure rollbacked subtransactions aren't decoded BEGIN; @@ -339,12 +1015,337 @@ COMMIT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ----------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 33 + sequence tr_etoomuch_id_seq advanced to 66 + sequence tr_etoomuch_id_seq advanced to 99 + sequence tr_etoomuch_id_seq advanced to 132 + sequence tr_etoomuch_id_seq advanced to 165 + sequence tr_etoomuch_id_seq advanced to 198 + sequence tr_etoomuch_id_seq advanced to 231 + sequence tr_etoomuch_id_seq advanced to 264 + sequence tr_etoomuch_id_seq advanced to 297 + sequence tr_etoomuch_id_seq advanced to 330 + sequence tr_etoomuch_id_seq advanced to 363 + sequence tr_etoomuch_id_seq advanced to 396 + sequence tr_etoomuch_id_seq advanced to 429 + sequence tr_etoomuch_id_seq advanced to 462 + sequence tr_etoomuch_id_seq advanced to 495 + sequence tr_etoomuch_id_seq advanced to 528 + sequence tr_etoomuch_id_seq advanced to 561 + sequence tr_etoomuch_id_seq advanced to 594 + sequence tr_etoomuch_id_seq advanced to 627 + sequence tr_etoomuch_id_seq advanced to 660 + sequence tr_etoomuch_id_seq advanced to 693 + sequence tr_etoomuch_id_seq advanced to 726 + sequence tr_etoomuch_id_seq advanced to 759 + sequence tr_etoomuch_id_seq advanced to 792 + sequence tr_etoomuch_id_seq advanced to 825 + sequence tr_etoomuch_id_seq advanced to 858 + sequence tr_etoomuch_id_seq advanced to 891 + sequence tr_etoomuch_id_seq advanced to 924 + sequence tr_etoomuch_id_seq advanced to 957 + sequence tr_etoomuch_id_seq advanced to 990 + sequence tr_etoomuch_id_seq advanced to 1023 + sequence tr_etoomuch_id_seq advanced to 1056 + sequence tr_etoomuch_id_seq advanced to 1089 + sequence tr_etoomuch_id_seq advanced to 1122 + sequence tr_etoomuch_id_seq advanced to 1155 + sequence tr_etoomuch_id_seq advanced to 1188 + sequence tr_etoomuch_id_seq advanced to 1221 + sequence tr_etoomuch_id_seq advanced to 1254 + sequence tr_etoomuch_id_seq advanced to 1287 + sequence tr_etoomuch_id_seq advanced to 1320 + sequence tr_etoomuch_id_seq advanced to 1353 + sequence tr_etoomuch_id_seq advanced to 1386 + sequence tr_etoomuch_id_seq advanced to 1419 + sequence tr_etoomuch_id_seq advanced to 1452 + sequence tr_etoomuch_id_seq advanced to 1485 + sequence tr_etoomuch_id_seq advanced to 1518 + sequence tr_etoomuch_id_seq advanced to 1551 + sequence tr_etoomuch_id_seq advanced to 1584 + sequence tr_etoomuch_id_seq advanced to 1617 + sequence tr_etoomuch_id_seq advanced to 1650 + sequence tr_etoomuch_id_seq advanced to 1683 + sequence tr_etoomuch_id_seq advanced to 1716 + sequence tr_etoomuch_id_seq advanced to 1749 + sequence tr_etoomuch_id_seq advanced to 1782 + sequence tr_etoomuch_id_seq advanced to 1815 + sequence tr_etoomuch_id_seq advanced to 1848 + sequence tr_etoomuch_id_seq advanced to 1881 + sequence tr_etoomuch_id_seq advanced to 1914 + sequence tr_etoomuch_id_seq advanced to 1947 + sequence tr_etoomuch_id_seq advanced to 1980 + sequence tr_etoomuch_id_seq advanced to 2013 + sequence tr_etoomuch_id_seq advanced to 2046 + sequence tr_etoomuch_id_seq advanced to 2079 + sequence tr_etoomuch_id_seq advanced to 2112 + sequence tr_etoomuch_id_seq advanced to 2145 + sequence tr_etoomuch_id_seq advanced to 2178 + sequence tr_etoomuch_id_seq advanced to 2211 + sequence tr_etoomuch_id_seq advanced to 2244 + sequence tr_etoomuch_id_seq advanced to 2277 + sequence tr_etoomuch_id_seq advanced to 2310 + sequence tr_etoomuch_id_seq advanced to 2343 + sequence tr_etoomuch_id_seq advanced to 2376 + sequence tr_etoomuch_id_seq advanced to 2409 + sequence tr_etoomuch_id_seq advanced to 2442 + sequence tr_etoomuch_id_seq advanced to 2475 + sequence tr_etoomuch_id_seq advanced to 2508 + sequence tr_etoomuch_id_seq advanced to 2541 + sequence tr_etoomuch_id_seq advanced to 2574 + sequence tr_etoomuch_id_seq advanced to 2607 + sequence tr_etoomuch_id_seq advanced to 2640 + sequence tr_etoomuch_id_seq advanced to 2673 + sequence tr_etoomuch_id_seq advanced to 2706 + sequence tr_etoomuch_id_seq advanced to 2739 + sequence tr_etoomuch_id_seq advanced to 2772 + sequence tr_etoomuch_id_seq advanced to 2805 + sequence tr_etoomuch_id_seq advanced to 2838 + sequence tr_etoomuch_id_seq advanced to 2871 + sequence tr_etoomuch_id_seq advanced to 2904 + sequence tr_etoomuch_id_seq advanced to 2937 + sequence tr_etoomuch_id_seq advanced to 2970 + sequence tr_etoomuch_id_seq advanced to 3003 + sequence tr_etoomuch_id_seq advanced to 3036 + sequence tr_etoomuch_id_seq advanced to 3069 + sequence tr_etoomuch_id_seq advanced to 3102 + sequence tr_etoomuch_id_seq advanced to 3135 + sequence tr_etoomuch_id_seq advanced to 3168 + sequence tr_etoomuch_id_seq advanced to 3201 + sequence tr_etoomuch_id_seq advanced to 3234 + sequence tr_etoomuch_id_seq advanced to 3267 + sequence tr_etoomuch_id_seq advanced to 3300 + sequence tr_etoomuch_id_seq advanced to 3333 + sequence tr_etoomuch_id_seq advanced to 3366 + sequence tr_etoomuch_id_seq advanced to 3399 + sequence tr_etoomuch_id_seq advanced to 3432 + sequence tr_etoomuch_id_seq advanced to 3465 + sequence tr_etoomuch_id_seq advanced to 3498 + sequence tr_etoomuch_id_seq advanced to 3531 + sequence tr_etoomuch_id_seq advanced to 3564 + sequence tr_etoomuch_id_seq advanced to 3597 + sequence tr_etoomuch_id_seq advanced to 3630 + sequence tr_etoomuch_id_seq advanced to 3663 + sequence tr_etoomuch_id_seq advanced to 3696 + sequence tr_etoomuch_id_seq advanced to 3729 + sequence tr_etoomuch_id_seq advanced to 3762 + sequence tr_etoomuch_id_seq advanced to 3795 + sequence tr_etoomuch_id_seq advanced to 3828 + sequence tr_etoomuch_id_seq advanced to 3861 + sequence tr_etoomuch_id_seq advanced to 3894 + sequence tr_etoomuch_id_seq advanced to 3927 + sequence tr_etoomuch_id_seq advanced to 3960 + sequence tr_etoomuch_id_seq advanced to 3993 + sequence tr_etoomuch_id_seq advanced to 4026 + sequence tr_etoomuch_id_seq advanced to 4059 + sequence tr_etoomuch_id_seq advanced to 4092 + sequence tr_etoomuch_id_seq advanced to 4125 + sequence tr_etoomuch_id_seq advanced to 4158 + sequence tr_etoomuch_id_seq advanced to 4191 + sequence tr_etoomuch_id_seq advanced to 4224 + sequence tr_etoomuch_id_seq advanced to 4257 + sequence tr_etoomuch_id_seq advanced to 4290 + sequence tr_etoomuch_id_seq advanced to 4323 + sequence tr_etoomuch_id_seq advanced to 4356 + sequence tr_etoomuch_id_seq advanced to 4389 + sequence tr_etoomuch_id_seq advanced to 4422 + sequence tr_etoomuch_id_seq advanced to 4455 + sequence tr_etoomuch_id_seq advanced to 4488 + sequence tr_etoomuch_id_seq advanced to 4521 + sequence tr_etoomuch_id_seq advanced to 4554 + sequence tr_etoomuch_id_seq advanced to 4587 + sequence tr_etoomuch_id_seq advanced to 4620 + sequence tr_etoomuch_id_seq advanced to 4653 + sequence tr_etoomuch_id_seq advanced to 4686 + sequence tr_etoomuch_id_seq advanced to 4719 + sequence tr_etoomuch_id_seq advanced to 4752 + sequence tr_etoomuch_id_seq advanced to 4785 + sequence tr_etoomuch_id_seq advanced to 4818 + sequence tr_etoomuch_id_seq advanced to 4851 + sequence tr_etoomuch_id_seq advanced to 4884 + sequence tr_etoomuch_id_seq advanced to 4917 + sequence tr_etoomuch_id_seq advanced to 4950 + sequence tr_etoomuch_id_seq advanced to 4983 + sequence tr_etoomuch_id_seq advanced to 5016 + sequence tr_etoomuch_id_seq advanced to 5049 + sequence tr_etoomuch_id_seq advanced to 5082 + sequence tr_etoomuch_id_seq advanced to 5115 + sequence tr_etoomuch_id_seq advanced to 5148 + sequence tr_etoomuch_id_seq advanced to 5181 + sequence tr_etoomuch_id_seq advanced to 5214 + sequence tr_etoomuch_id_seq advanced to 5247 + sequence tr_etoomuch_id_seq advanced to 5280 + sequence tr_etoomuch_id_seq advanced to 5313 + sequence tr_etoomuch_id_seq advanced to 5346 + sequence tr_etoomuch_id_seq advanced to 5379 + sequence tr_etoomuch_id_seq advanced to 5412 + sequence tr_etoomuch_id_seq advanced to 5445 + sequence tr_etoomuch_id_seq advanced to 5478 + sequence tr_etoomuch_id_seq advanced to 5511 + sequence tr_etoomuch_id_seq advanced to 5544 + sequence tr_etoomuch_id_seq advanced to 5577 + sequence tr_etoomuch_id_seq advanced to 5610 + sequence tr_etoomuch_id_seq advanced to 5643 + sequence tr_etoomuch_id_seq advanced to 5676 + sequence tr_etoomuch_id_seq advanced to 5709 + sequence tr_etoomuch_id_seq advanced to 5742 + sequence tr_etoomuch_id_seq advanced to 5775 + sequence tr_etoomuch_id_seq advanced to 5808 + sequence tr_etoomuch_id_seq advanced to 5841 + sequence tr_etoomuch_id_seq advanced to 5874 + sequence tr_etoomuch_id_seq advanced to 5907 + sequence tr_etoomuch_id_seq advanced to 5940 + sequence tr_etoomuch_id_seq advanced to 5973 + sequence tr_etoomuch_id_seq advanced to 6006 + sequence tr_etoomuch_id_seq advanced to 6039 + sequence tr_etoomuch_id_seq advanced to 6072 + sequence tr_etoomuch_id_seq advanced to 6105 + sequence tr_etoomuch_id_seq advanced to 6138 + sequence tr_etoomuch_id_seq advanced to 6171 + sequence tr_etoomuch_id_seq advanced to 6204 + sequence tr_etoomuch_id_seq advanced to 6237 + sequence tr_etoomuch_id_seq advanced to 6270 + sequence tr_etoomuch_id_seq advanced to 6303 + sequence tr_etoomuch_id_seq advanced to 6336 + sequence tr_etoomuch_id_seq advanced to 6369 + sequence tr_etoomuch_id_seq advanced to 6402 + sequence tr_etoomuch_id_seq advanced to 6435 + sequence tr_etoomuch_id_seq advanced to 6468 + sequence tr_etoomuch_id_seq advanced to 6501 + sequence tr_etoomuch_id_seq advanced to 6534 + sequence tr_etoomuch_id_seq advanced to 6567 + sequence tr_etoomuch_id_seq advanced to 6600 + sequence tr_etoomuch_id_seq advanced to 6633 + sequence tr_etoomuch_id_seq advanced to 6666 + sequence tr_etoomuch_id_seq advanced to 6699 + sequence tr_etoomuch_id_seq advanced to 6732 + sequence tr_etoomuch_id_seq advanced to 6765 + sequence tr_etoomuch_id_seq advanced to 6798 + sequence tr_etoomuch_id_seq advanced to 6831 + sequence tr_etoomuch_id_seq advanced to 6864 + sequence tr_etoomuch_id_seq advanced to 6897 + sequence tr_etoomuch_id_seq advanced to 6930 + sequence tr_etoomuch_id_seq advanced to 6963 + sequence tr_etoomuch_id_seq advanced to 6996 + sequence tr_etoomuch_id_seq advanced to 7029 + sequence tr_etoomuch_id_seq advanced to 7062 + sequence tr_etoomuch_id_seq advanced to 7095 + sequence tr_etoomuch_id_seq advanced to 7128 + sequence tr_etoomuch_id_seq advanced to 7161 + sequence tr_etoomuch_id_seq advanced to 7194 + sequence tr_etoomuch_id_seq advanced to 7227 + sequence tr_etoomuch_id_seq advanced to 7260 + sequence tr_etoomuch_id_seq advanced to 7293 + sequence tr_etoomuch_id_seq advanced to 7326 + sequence tr_etoomuch_id_seq advanced to 7359 + sequence tr_etoomuch_id_seq advanced to 7392 + sequence tr_etoomuch_id_seq advanced to 7425 + sequence tr_etoomuch_id_seq advanced to 7458 + sequence tr_etoomuch_id_seq advanced to 7491 + sequence tr_etoomuch_id_seq advanced to 7524 + sequence tr_etoomuch_id_seq advanced to 7557 + sequence tr_etoomuch_id_seq advanced to 7590 + sequence tr_etoomuch_id_seq advanced to 7623 + sequence tr_etoomuch_id_seq advanced to 7656 + sequence tr_etoomuch_id_seq advanced to 7689 + sequence tr_etoomuch_id_seq advanced to 7722 + sequence tr_etoomuch_id_seq advanced to 7755 + sequence tr_etoomuch_id_seq advanced to 7788 + sequence tr_etoomuch_id_seq advanced to 7821 + sequence tr_etoomuch_id_seq advanced to 7854 + sequence tr_etoomuch_id_seq advanced to 7887 + sequence tr_etoomuch_id_seq advanced to 7920 + sequence tr_etoomuch_id_seq advanced to 7953 + sequence tr_etoomuch_id_seq advanced to 7986 + sequence tr_etoomuch_id_seq advanced to 8019 + sequence tr_etoomuch_id_seq advanced to 8052 + sequence tr_etoomuch_id_seq advanced to 8085 + sequence tr_etoomuch_id_seq advanced to 8118 + sequence tr_etoomuch_id_seq advanced to 8151 + sequence tr_etoomuch_id_seq advanced to 8184 + sequence tr_etoomuch_id_seq advanced to 8217 + sequence tr_etoomuch_id_seq advanced to 8250 + sequence tr_etoomuch_id_seq advanced to 8283 + sequence tr_etoomuch_id_seq advanced to 8316 + sequence tr_etoomuch_id_seq advanced to 8349 + sequence tr_etoomuch_id_seq advanced to 8382 + sequence tr_etoomuch_id_seq advanced to 8415 + sequence tr_etoomuch_id_seq advanced to 8448 + sequence tr_etoomuch_id_seq advanced to 8481 + sequence tr_etoomuch_id_seq advanced to 8514 + sequence tr_etoomuch_id_seq advanced to 8547 + sequence tr_etoomuch_id_seq advanced to 8580 + sequence tr_etoomuch_id_seq advanced to 8613 + sequence tr_etoomuch_id_seq advanced to 8646 + sequence tr_etoomuch_id_seq advanced to 8679 + sequence tr_etoomuch_id_seq advanced to 8712 + sequence tr_etoomuch_id_seq advanced to 8745 + sequence tr_etoomuch_id_seq advanced to 8778 + sequence tr_etoomuch_id_seq advanced to 8811 + sequence tr_etoomuch_id_seq advanced to 8844 + sequence tr_etoomuch_id_seq advanced to 8877 + sequence tr_etoomuch_id_seq advanced to 8910 + sequence tr_etoomuch_id_seq advanced to 8943 + sequence tr_etoomuch_id_seq advanced to 8976 + sequence tr_etoomuch_id_seq advanced to 9009 + sequence tr_etoomuch_id_seq advanced to 9042 + sequence tr_etoomuch_id_seq advanced to 9075 + sequence tr_etoomuch_id_seq advanced to 9108 + sequence tr_etoomuch_id_seq advanced to 9141 + sequence tr_etoomuch_id_seq advanced to 9174 + sequence tr_etoomuch_id_seq advanced to 9207 + sequence tr_etoomuch_id_seq advanced to 9240 + sequence tr_etoomuch_id_seq advanced to 9273 + sequence tr_etoomuch_id_seq advanced to 9306 + sequence tr_etoomuch_id_seq advanced to 9339 + sequence tr_etoomuch_id_seq advanced to 9372 + sequence tr_etoomuch_id_seq advanced to 9405 + sequence tr_etoomuch_id_seq advanced to 9438 + sequence tr_etoomuch_id_seq advanced to 9471 + sequence tr_etoomuch_id_seq advanced to 9504 + sequence tr_etoomuch_id_seq advanced to 9537 + sequence tr_etoomuch_id_seq advanced to 9570 + sequence tr_etoomuch_id_seq advanced to 9603 + sequence tr_etoomuch_id_seq advanced to 9636 + sequence tr_etoomuch_id_seq advanced to 9669 + sequence tr_etoomuch_id_seq advanced to 9702 + sequence tr_etoomuch_id_seq advanced to 9735 + sequence tr_etoomuch_id_seq advanced to 9768 + sequence tr_etoomuch_id_seq advanced to 9801 + sequence tr_etoomuch_id_seq advanced to 9834 + sequence tr_etoomuch_id_seq advanced to 9867 + sequence tr_etoomuch_id_seq advanced to 9900 + sequence tr_etoomuch_id_seq advanced to 9933 + sequence tr_etoomuch_id_seq advanced to 9966 + sequence tr_etoomuch_id_seq advanced to 9999 + sequence tr_etoomuch_id_seq advanced to 10032 + sequence tr_etoomuch_id_seq advanced to 10065 + sequence tr_etoomuch_id_seq advanced to 10098 + sequence tr_etoomuch_id_seq advanced to 10131 + sequence tr_etoomuch_id_seq advanced to 10164 + sequence tr_etoomuch_id_seq advanced to 10197 + sequence tr_etoomuch_id_seq advanced to 10230 + sequence tr_etoomuch_id_seq advanced to 10263 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 33 BEGIN table public.tr_sub: INSERT: id[integer]:11 path[text]:'3-top-2-#1' table public.tr_sub: INSERT: id[integer]:12 path[text]:'3-top-2-1-#1' table public.tr_sub: INSERT: id[integer]:14 path[text]:'3-top-2-#2' COMMIT -(5 rows) +(330 rows) -- test whether a known, but not yet logged toplevel xact, followed by a -- subxact commit is handled correctly @@ -368,13 +1369,338 @@ COMMIT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data --------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 33 + sequence tr_etoomuch_id_seq advanced to 66 + sequence tr_etoomuch_id_seq advanced to 99 + sequence tr_etoomuch_id_seq advanced to 132 + sequence tr_etoomuch_id_seq advanced to 165 + sequence tr_etoomuch_id_seq advanced to 198 + sequence tr_etoomuch_id_seq advanced to 231 + sequence tr_etoomuch_id_seq advanced to 264 + sequence tr_etoomuch_id_seq advanced to 297 + sequence tr_etoomuch_id_seq advanced to 330 + sequence tr_etoomuch_id_seq advanced to 363 + sequence tr_etoomuch_id_seq advanced to 396 + sequence tr_etoomuch_id_seq advanced to 429 + sequence tr_etoomuch_id_seq advanced to 462 + sequence tr_etoomuch_id_seq advanced to 495 + sequence tr_etoomuch_id_seq advanced to 528 + sequence tr_etoomuch_id_seq advanced to 561 + sequence tr_etoomuch_id_seq advanced to 594 + sequence tr_etoomuch_id_seq advanced to 627 + sequence tr_etoomuch_id_seq advanced to 660 + sequence tr_etoomuch_id_seq advanced to 693 + sequence tr_etoomuch_id_seq advanced to 726 + sequence tr_etoomuch_id_seq advanced to 759 + sequence tr_etoomuch_id_seq advanced to 792 + sequence tr_etoomuch_id_seq advanced to 825 + sequence tr_etoomuch_id_seq advanced to 858 + sequence tr_etoomuch_id_seq advanced to 891 + sequence tr_etoomuch_id_seq advanced to 924 + sequence tr_etoomuch_id_seq advanced to 957 + sequence tr_etoomuch_id_seq advanced to 990 + sequence tr_etoomuch_id_seq advanced to 1023 + sequence tr_etoomuch_id_seq advanced to 1056 + sequence tr_etoomuch_id_seq advanced to 1089 + sequence tr_etoomuch_id_seq advanced to 1122 + sequence tr_etoomuch_id_seq advanced to 1155 + sequence tr_etoomuch_id_seq advanced to 1188 + sequence tr_etoomuch_id_seq advanced to 1221 + sequence tr_etoomuch_id_seq advanced to 1254 + sequence tr_etoomuch_id_seq advanced to 1287 + sequence tr_etoomuch_id_seq advanced to 1320 + sequence tr_etoomuch_id_seq advanced to 1353 + sequence tr_etoomuch_id_seq advanced to 1386 + sequence tr_etoomuch_id_seq advanced to 1419 + sequence tr_etoomuch_id_seq advanced to 1452 + sequence tr_etoomuch_id_seq advanced to 1485 + sequence tr_etoomuch_id_seq advanced to 1518 + sequence tr_etoomuch_id_seq advanced to 1551 + sequence tr_etoomuch_id_seq advanced to 1584 + sequence tr_etoomuch_id_seq advanced to 1617 + sequence tr_etoomuch_id_seq advanced to 1650 + sequence tr_etoomuch_id_seq advanced to 1683 + sequence tr_etoomuch_id_seq advanced to 1716 + sequence tr_etoomuch_id_seq advanced to 1749 + sequence tr_etoomuch_id_seq advanced to 1782 + sequence tr_etoomuch_id_seq advanced to 1815 + sequence tr_etoomuch_id_seq advanced to 1848 + sequence tr_etoomuch_id_seq advanced to 1881 + sequence tr_etoomuch_id_seq advanced to 1914 + sequence tr_etoomuch_id_seq advanced to 1947 + sequence tr_etoomuch_id_seq advanced to 1980 + sequence tr_etoomuch_id_seq advanced to 2013 + sequence tr_etoomuch_id_seq advanced to 2046 + sequence tr_etoomuch_id_seq advanced to 2079 + sequence tr_etoomuch_id_seq advanced to 2112 + sequence tr_etoomuch_id_seq advanced to 2145 + sequence tr_etoomuch_id_seq advanced to 2178 + sequence tr_etoomuch_id_seq advanced to 2211 + sequence tr_etoomuch_id_seq advanced to 2244 + sequence tr_etoomuch_id_seq advanced to 2277 + sequence tr_etoomuch_id_seq advanced to 2310 + sequence tr_etoomuch_id_seq advanced to 2343 + sequence tr_etoomuch_id_seq advanced to 2376 + sequence tr_etoomuch_id_seq advanced to 2409 + sequence tr_etoomuch_id_seq advanced to 2442 + sequence tr_etoomuch_id_seq advanced to 2475 + sequence tr_etoomuch_id_seq advanced to 2508 + sequence tr_etoomuch_id_seq advanced to 2541 + sequence tr_etoomuch_id_seq advanced to 2574 + sequence tr_etoomuch_id_seq advanced to 2607 + sequence tr_etoomuch_id_seq advanced to 2640 + sequence tr_etoomuch_id_seq advanced to 2673 + sequence tr_etoomuch_id_seq advanced to 2706 + sequence tr_etoomuch_id_seq advanced to 2739 + sequence tr_etoomuch_id_seq advanced to 2772 + sequence tr_etoomuch_id_seq advanced to 2805 + sequence tr_etoomuch_id_seq advanced to 2838 + sequence tr_etoomuch_id_seq advanced to 2871 + sequence tr_etoomuch_id_seq advanced to 2904 + sequence tr_etoomuch_id_seq advanced to 2937 + sequence tr_etoomuch_id_seq advanced to 2970 + sequence tr_etoomuch_id_seq advanced to 3003 + sequence tr_etoomuch_id_seq advanced to 3036 + sequence tr_etoomuch_id_seq advanced to 3069 + sequence tr_etoomuch_id_seq advanced to 3102 + sequence tr_etoomuch_id_seq advanced to 3135 + sequence tr_etoomuch_id_seq advanced to 3168 + sequence tr_etoomuch_id_seq advanced to 3201 + sequence tr_etoomuch_id_seq advanced to 3234 + sequence tr_etoomuch_id_seq advanced to 3267 + sequence tr_etoomuch_id_seq advanced to 3300 + sequence tr_etoomuch_id_seq advanced to 3333 + sequence tr_etoomuch_id_seq advanced to 3366 + sequence tr_etoomuch_id_seq advanced to 3399 + sequence tr_etoomuch_id_seq advanced to 3432 + sequence tr_etoomuch_id_seq advanced to 3465 + sequence tr_etoomuch_id_seq advanced to 3498 + sequence tr_etoomuch_id_seq advanced to 3531 + sequence tr_etoomuch_id_seq advanced to 3564 + sequence tr_etoomuch_id_seq advanced to 3597 + sequence tr_etoomuch_id_seq advanced to 3630 + sequence tr_etoomuch_id_seq advanced to 3663 + sequence tr_etoomuch_id_seq advanced to 3696 + sequence tr_etoomuch_id_seq advanced to 3729 + sequence tr_etoomuch_id_seq advanced to 3762 + sequence tr_etoomuch_id_seq advanced to 3795 + sequence tr_etoomuch_id_seq advanced to 3828 + sequence tr_etoomuch_id_seq advanced to 3861 + sequence tr_etoomuch_id_seq advanced to 3894 + sequence tr_etoomuch_id_seq advanced to 3927 + sequence tr_etoomuch_id_seq advanced to 3960 + sequence tr_etoomuch_id_seq advanced to 3993 + sequence tr_etoomuch_id_seq advanced to 4026 + sequence tr_etoomuch_id_seq advanced to 4059 + sequence tr_etoomuch_id_seq advanced to 4092 + sequence tr_etoomuch_id_seq advanced to 4125 + sequence tr_etoomuch_id_seq advanced to 4158 + sequence tr_etoomuch_id_seq advanced to 4191 + sequence tr_etoomuch_id_seq advanced to 4224 + sequence tr_etoomuch_id_seq advanced to 4257 + sequence tr_etoomuch_id_seq advanced to 4290 + sequence tr_etoomuch_id_seq advanced to 4323 + sequence tr_etoomuch_id_seq advanced to 4356 + sequence tr_etoomuch_id_seq advanced to 4389 + sequence tr_etoomuch_id_seq advanced to 4422 + sequence tr_etoomuch_id_seq advanced to 4455 + sequence tr_etoomuch_id_seq advanced to 4488 + sequence tr_etoomuch_id_seq advanced to 4521 + sequence tr_etoomuch_id_seq advanced to 4554 + sequence tr_etoomuch_id_seq advanced to 4587 + sequence tr_etoomuch_id_seq advanced to 4620 + sequence tr_etoomuch_id_seq advanced to 4653 + sequence tr_etoomuch_id_seq advanced to 4686 + sequence tr_etoomuch_id_seq advanced to 4719 + sequence tr_etoomuch_id_seq advanced to 4752 + sequence tr_etoomuch_id_seq advanced to 4785 + sequence tr_etoomuch_id_seq advanced to 4818 + sequence tr_etoomuch_id_seq advanced to 4851 + sequence tr_etoomuch_id_seq advanced to 4884 + sequence tr_etoomuch_id_seq advanced to 4917 + sequence tr_etoomuch_id_seq advanced to 4950 + sequence tr_etoomuch_id_seq advanced to 4983 + sequence tr_etoomuch_id_seq advanced to 5016 + sequence tr_etoomuch_id_seq advanced to 5049 + sequence tr_etoomuch_id_seq advanced to 5082 + sequence tr_etoomuch_id_seq advanced to 5115 + sequence tr_etoomuch_id_seq advanced to 5148 + sequence tr_etoomuch_id_seq advanced to 5181 + sequence tr_etoomuch_id_seq advanced to 5214 + sequence tr_etoomuch_id_seq advanced to 5247 + sequence tr_etoomuch_id_seq advanced to 5280 + sequence tr_etoomuch_id_seq advanced to 5313 + sequence tr_etoomuch_id_seq advanced to 5346 + sequence tr_etoomuch_id_seq advanced to 5379 + sequence tr_etoomuch_id_seq advanced to 5412 + sequence tr_etoomuch_id_seq advanced to 5445 + sequence tr_etoomuch_id_seq advanced to 5478 + sequence tr_etoomuch_id_seq advanced to 5511 + sequence tr_etoomuch_id_seq advanced to 5544 + sequence tr_etoomuch_id_seq advanced to 5577 + sequence tr_etoomuch_id_seq advanced to 5610 + sequence tr_etoomuch_id_seq advanced to 5643 + sequence tr_etoomuch_id_seq advanced to 5676 + sequence tr_etoomuch_id_seq advanced to 5709 + sequence tr_etoomuch_id_seq advanced to 5742 + sequence tr_etoomuch_id_seq advanced to 5775 + sequence tr_etoomuch_id_seq advanced to 5808 + sequence tr_etoomuch_id_seq advanced to 5841 + sequence tr_etoomuch_id_seq advanced to 5874 + sequence tr_etoomuch_id_seq advanced to 5907 + sequence tr_etoomuch_id_seq advanced to 5940 + sequence tr_etoomuch_id_seq advanced to 5973 + sequence tr_etoomuch_id_seq advanced to 6006 + sequence tr_etoomuch_id_seq advanced to 6039 + sequence tr_etoomuch_id_seq advanced to 6072 + sequence tr_etoomuch_id_seq advanced to 6105 + sequence tr_etoomuch_id_seq advanced to 6138 + sequence tr_etoomuch_id_seq advanced to 6171 + sequence tr_etoomuch_id_seq advanced to 6204 + sequence tr_etoomuch_id_seq advanced to 6237 + sequence tr_etoomuch_id_seq advanced to 6270 + sequence tr_etoomuch_id_seq advanced to 6303 + sequence tr_etoomuch_id_seq advanced to 6336 + sequence tr_etoomuch_id_seq advanced to 6369 + sequence tr_etoomuch_id_seq advanced to 6402 + sequence tr_etoomuch_id_seq advanced to 6435 + sequence tr_etoomuch_id_seq advanced to 6468 + sequence tr_etoomuch_id_seq advanced to 6501 + sequence tr_etoomuch_id_seq advanced to 6534 + sequence tr_etoomuch_id_seq advanced to 6567 + sequence tr_etoomuch_id_seq advanced to 6600 + sequence tr_etoomuch_id_seq advanced to 6633 + sequence tr_etoomuch_id_seq advanced to 6666 + sequence tr_etoomuch_id_seq advanced to 6699 + sequence tr_etoomuch_id_seq advanced to 6732 + sequence tr_etoomuch_id_seq advanced to 6765 + sequence tr_etoomuch_id_seq advanced to 6798 + sequence tr_etoomuch_id_seq advanced to 6831 + sequence tr_etoomuch_id_seq advanced to 6864 + sequence tr_etoomuch_id_seq advanced to 6897 + sequence tr_etoomuch_id_seq advanced to 6930 + sequence tr_etoomuch_id_seq advanced to 6963 + sequence tr_etoomuch_id_seq advanced to 6996 + sequence tr_etoomuch_id_seq advanced to 7029 + sequence tr_etoomuch_id_seq advanced to 7062 + sequence tr_etoomuch_id_seq advanced to 7095 + sequence tr_etoomuch_id_seq advanced to 7128 + sequence tr_etoomuch_id_seq advanced to 7161 + sequence tr_etoomuch_id_seq advanced to 7194 + sequence tr_etoomuch_id_seq advanced to 7227 + sequence tr_etoomuch_id_seq advanced to 7260 + sequence tr_etoomuch_id_seq advanced to 7293 + sequence tr_etoomuch_id_seq advanced to 7326 + sequence tr_etoomuch_id_seq advanced to 7359 + sequence tr_etoomuch_id_seq advanced to 7392 + sequence tr_etoomuch_id_seq advanced to 7425 + sequence tr_etoomuch_id_seq advanced to 7458 + sequence tr_etoomuch_id_seq advanced to 7491 + sequence tr_etoomuch_id_seq advanced to 7524 + sequence tr_etoomuch_id_seq advanced to 7557 + sequence tr_etoomuch_id_seq advanced to 7590 + sequence tr_etoomuch_id_seq advanced to 7623 + sequence tr_etoomuch_id_seq advanced to 7656 + sequence tr_etoomuch_id_seq advanced to 7689 + sequence tr_etoomuch_id_seq advanced to 7722 + sequence tr_etoomuch_id_seq advanced to 7755 + sequence tr_etoomuch_id_seq advanced to 7788 + sequence tr_etoomuch_id_seq advanced to 7821 + sequence tr_etoomuch_id_seq advanced to 7854 + sequence tr_etoomuch_id_seq advanced to 7887 + sequence tr_etoomuch_id_seq advanced to 7920 + sequence tr_etoomuch_id_seq advanced to 7953 + sequence tr_etoomuch_id_seq advanced to 7986 + sequence tr_etoomuch_id_seq advanced to 8019 + sequence tr_etoomuch_id_seq advanced to 8052 + sequence tr_etoomuch_id_seq advanced to 8085 + sequence tr_etoomuch_id_seq advanced to 8118 + sequence tr_etoomuch_id_seq advanced to 8151 + sequence tr_etoomuch_id_seq advanced to 8184 + sequence tr_etoomuch_id_seq advanced to 8217 + sequence tr_etoomuch_id_seq advanced to 8250 + sequence tr_etoomuch_id_seq advanced to 8283 + sequence tr_etoomuch_id_seq advanced to 8316 + sequence tr_etoomuch_id_seq advanced to 8349 + sequence tr_etoomuch_id_seq advanced to 8382 + sequence tr_etoomuch_id_seq advanced to 8415 + sequence tr_etoomuch_id_seq advanced to 8448 + sequence tr_etoomuch_id_seq advanced to 8481 + sequence tr_etoomuch_id_seq advanced to 8514 + sequence tr_etoomuch_id_seq advanced to 8547 + sequence tr_etoomuch_id_seq advanced to 8580 + sequence tr_etoomuch_id_seq advanced to 8613 + sequence tr_etoomuch_id_seq advanced to 8646 + sequence tr_etoomuch_id_seq advanced to 8679 + sequence tr_etoomuch_id_seq advanced to 8712 + sequence tr_etoomuch_id_seq advanced to 8745 + sequence tr_etoomuch_id_seq advanced to 8778 + sequence tr_etoomuch_id_seq advanced to 8811 + sequence tr_etoomuch_id_seq advanced to 8844 + sequence tr_etoomuch_id_seq advanced to 8877 + sequence tr_etoomuch_id_seq advanced to 8910 + sequence tr_etoomuch_id_seq advanced to 8943 + sequence tr_etoomuch_id_seq advanced to 8976 + sequence tr_etoomuch_id_seq advanced to 9009 + sequence tr_etoomuch_id_seq advanced to 9042 + sequence tr_etoomuch_id_seq advanced to 9075 + sequence tr_etoomuch_id_seq advanced to 9108 + sequence tr_etoomuch_id_seq advanced to 9141 + sequence tr_etoomuch_id_seq advanced to 9174 + sequence tr_etoomuch_id_seq advanced to 9207 + sequence tr_etoomuch_id_seq advanced to 9240 + sequence tr_etoomuch_id_seq advanced to 9273 + sequence tr_etoomuch_id_seq advanced to 9306 + sequence tr_etoomuch_id_seq advanced to 9339 + sequence tr_etoomuch_id_seq advanced to 9372 + sequence tr_etoomuch_id_seq advanced to 9405 + sequence tr_etoomuch_id_seq advanced to 9438 + sequence tr_etoomuch_id_seq advanced to 9471 + sequence tr_etoomuch_id_seq advanced to 9504 + sequence tr_etoomuch_id_seq advanced to 9537 + sequence tr_etoomuch_id_seq advanced to 9570 + sequence tr_etoomuch_id_seq advanced to 9603 + sequence tr_etoomuch_id_seq advanced to 9636 + sequence tr_etoomuch_id_seq advanced to 9669 + sequence tr_etoomuch_id_seq advanced to 9702 + sequence tr_etoomuch_id_seq advanced to 9735 + sequence tr_etoomuch_id_seq advanced to 9768 + sequence tr_etoomuch_id_seq advanced to 9801 + sequence tr_etoomuch_id_seq advanced to 9834 + sequence tr_etoomuch_id_seq advanced to 9867 + sequence tr_etoomuch_id_seq advanced to 9900 + sequence tr_etoomuch_id_seq advanced to 9933 + sequence tr_etoomuch_id_seq advanced to 9966 + sequence tr_etoomuch_id_seq advanced to 9999 + sequence tr_etoomuch_id_seq advanced to 10032 + sequence tr_etoomuch_id_seq advanced to 10065 + sequence tr_etoomuch_id_seq advanced to 10098 + sequence tr_etoomuch_id_seq advanced to 10131 + sequence tr_etoomuch_id_seq advanced to 10164 + sequence tr_etoomuch_id_seq advanced to 10197 + sequence tr_etoomuch_id_seq advanced to 10230 + sequence tr_etoomuch_id_seq advanced to 10263 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 33 BEGIN table public.tr_sub: INSERT: id[integer]:15 path[text]:'4-top-1-#1' COMMIT BEGIN table public.tr_sub: INSERT: id[integer]:16 path[text]:'5-top-1-#1' COMMIT -(6 rows) +(331 rows) /* * Check whether treating a table as a catalog table works somewhat @@ -448,6 +1774,334 @@ VALUES ('zaphod', NULL); SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ------------------------------------------------------------------------------------------------------------------------------------ + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 33 + sequence tr_etoomuch_id_seq advanced to 66 + sequence tr_etoomuch_id_seq advanced to 99 + sequence tr_etoomuch_id_seq advanced to 132 + sequence tr_etoomuch_id_seq advanced to 165 + sequence tr_etoomuch_id_seq advanced to 198 + sequence tr_etoomuch_id_seq advanced to 231 + sequence tr_etoomuch_id_seq advanced to 264 + sequence tr_etoomuch_id_seq advanced to 297 + sequence tr_etoomuch_id_seq advanced to 330 + sequence tr_etoomuch_id_seq advanced to 363 + sequence tr_etoomuch_id_seq advanced to 396 + sequence tr_etoomuch_id_seq advanced to 429 + sequence tr_etoomuch_id_seq advanced to 462 + sequence tr_etoomuch_id_seq advanced to 495 + sequence tr_etoomuch_id_seq advanced to 528 + sequence tr_etoomuch_id_seq advanced to 561 + sequence tr_etoomuch_id_seq advanced to 594 + sequence tr_etoomuch_id_seq advanced to 627 + sequence tr_etoomuch_id_seq advanced to 660 + sequence tr_etoomuch_id_seq advanced to 693 + sequence tr_etoomuch_id_seq advanced to 726 + sequence tr_etoomuch_id_seq advanced to 759 + sequence tr_etoomuch_id_seq advanced to 792 + sequence tr_etoomuch_id_seq advanced to 825 + sequence tr_etoomuch_id_seq advanced to 858 + sequence tr_etoomuch_id_seq advanced to 891 + sequence tr_etoomuch_id_seq advanced to 924 + sequence tr_etoomuch_id_seq advanced to 957 + sequence tr_etoomuch_id_seq advanced to 990 + sequence tr_etoomuch_id_seq advanced to 1023 + sequence tr_etoomuch_id_seq advanced to 1056 + sequence tr_etoomuch_id_seq advanced to 1089 + sequence tr_etoomuch_id_seq advanced to 1122 + sequence tr_etoomuch_id_seq advanced to 1155 + sequence tr_etoomuch_id_seq advanced to 1188 + sequence tr_etoomuch_id_seq advanced to 1221 + sequence tr_etoomuch_id_seq advanced to 1254 + sequence tr_etoomuch_id_seq advanced to 1287 + sequence tr_etoomuch_id_seq advanced to 1320 + sequence tr_etoomuch_id_seq advanced to 1353 + sequence tr_etoomuch_id_seq advanced to 1386 + sequence tr_etoomuch_id_seq advanced to 1419 + sequence tr_etoomuch_id_seq advanced to 1452 + sequence tr_etoomuch_id_seq advanced to 1485 + sequence tr_etoomuch_id_seq advanced to 1518 + sequence tr_etoomuch_id_seq advanced to 1551 + sequence tr_etoomuch_id_seq advanced to 1584 + sequence tr_etoomuch_id_seq advanced to 1617 + sequence tr_etoomuch_id_seq advanced to 1650 + sequence tr_etoomuch_id_seq advanced to 1683 + sequence tr_etoomuch_id_seq advanced to 1716 + sequence tr_etoomuch_id_seq advanced to 1749 + sequence tr_etoomuch_id_seq advanced to 1782 + sequence tr_etoomuch_id_seq advanced to 1815 + sequence tr_etoomuch_id_seq advanced to 1848 + sequence tr_etoomuch_id_seq advanced to 1881 + sequence tr_etoomuch_id_seq advanced to 1914 + sequence tr_etoomuch_id_seq advanced to 1947 + sequence tr_etoomuch_id_seq advanced to 1980 + sequence tr_etoomuch_id_seq advanced to 2013 + sequence tr_etoomuch_id_seq advanced to 2046 + sequence tr_etoomuch_id_seq advanced to 2079 + sequence tr_etoomuch_id_seq advanced to 2112 + sequence tr_etoomuch_id_seq advanced to 2145 + sequence tr_etoomuch_id_seq advanced to 2178 + sequence tr_etoomuch_id_seq advanced to 2211 + sequence tr_etoomuch_id_seq advanced to 2244 + sequence tr_etoomuch_id_seq advanced to 2277 + sequence tr_etoomuch_id_seq advanced to 2310 + sequence tr_etoomuch_id_seq advanced to 2343 + sequence tr_etoomuch_id_seq advanced to 2376 + sequence tr_etoomuch_id_seq advanced to 2409 + sequence tr_etoomuch_id_seq advanced to 2442 + sequence tr_etoomuch_id_seq advanced to 2475 + sequence tr_etoomuch_id_seq advanced to 2508 + sequence tr_etoomuch_id_seq advanced to 2541 + sequence tr_etoomuch_id_seq advanced to 2574 + sequence tr_etoomuch_id_seq advanced to 2607 + sequence tr_etoomuch_id_seq advanced to 2640 + sequence tr_etoomuch_id_seq advanced to 2673 + sequence tr_etoomuch_id_seq advanced to 2706 + sequence tr_etoomuch_id_seq advanced to 2739 + sequence tr_etoomuch_id_seq advanced to 2772 + sequence tr_etoomuch_id_seq advanced to 2805 + sequence tr_etoomuch_id_seq advanced to 2838 + sequence tr_etoomuch_id_seq advanced to 2871 + sequence tr_etoomuch_id_seq advanced to 2904 + sequence tr_etoomuch_id_seq advanced to 2937 + sequence tr_etoomuch_id_seq advanced to 2970 + sequence tr_etoomuch_id_seq advanced to 3003 + sequence tr_etoomuch_id_seq advanced to 3036 + sequence tr_etoomuch_id_seq advanced to 3069 + sequence tr_etoomuch_id_seq advanced to 3102 + sequence tr_etoomuch_id_seq advanced to 3135 + sequence tr_etoomuch_id_seq advanced to 3168 + sequence tr_etoomuch_id_seq advanced to 3201 + sequence tr_etoomuch_id_seq advanced to 3234 + sequence tr_etoomuch_id_seq advanced to 3267 + sequence tr_etoomuch_id_seq advanced to 3300 + sequence tr_etoomuch_id_seq advanced to 3333 + sequence tr_etoomuch_id_seq advanced to 3366 + sequence tr_etoomuch_id_seq advanced to 3399 + sequence tr_etoomuch_id_seq advanced to 3432 + sequence tr_etoomuch_id_seq advanced to 3465 + sequence tr_etoomuch_id_seq advanced to 3498 + sequence tr_etoomuch_id_seq advanced to 3531 + sequence tr_etoomuch_id_seq advanced to 3564 + sequence tr_etoomuch_id_seq advanced to 3597 + sequence tr_etoomuch_id_seq advanced to 3630 + sequence tr_etoomuch_id_seq advanced to 3663 + sequence tr_etoomuch_id_seq advanced to 3696 + sequence tr_etoomuch_id_seq advanced to 3729 + sequence tr_etoomuch_id_seq advanced to 3762 + sequence tr_etoomuch_id_seq advanced to 3795 + sequence tr_etoomuch_id_seq advanced to 3828 + sequence tr_etoomuch_id_seq advanced to 3861 + sequence tr_etoomuch_id_seq advanced to 3894 + sequence tr_etoomuch_id_seq advanced to 3927 + sequence tr_etoomuch_id_seq advanced to 3960 + sequence tr_etoomuch_id_seq advanced to 3993 + sequence tr_etoomuch_id_seq advanced to 4026 + sequence tr_etoomuch_id_seq advanced to 4059 + sequence tr_etoomuch_id_seq advanced to 4092 + sequence tr_etoomuch_id_seq advanced to 4125 + sequence tr_etoomuch_id_seq advanced to 4158 + sequence tr_etoomuch_id_seq advanced to 4191 + sequence tr_etoomuch_id_seq advanced to 4224 + sequence tr_etoomuch_id_seq advanced to 4257 + sequence tr_etoomuch_id_seq advanced to 4290 + sequence tr_etoomuch_id_seq advanced to 4323 + sequence tr_etoomuch_id_seq advanced to 4356 + sequence tr_etoomuch_id_seq advanced to 4389 + sequence tr_etoomuch_id_seq advanced to 4422 + sequence tr_etoomuch_id_seq advanced to 4455 + sequence tr_etoomuch_id_seq advanced to 4488 + sequence tr_etoomuch_id_seq advanced to 4521 + sequence tr_etoomuch_id_seq advanced to 4554 + sequence tr_etoomuch_id_seq advanced to 4587 + sequence tr_etoomuch_id_seq advanced to 4620 + sequence tr_etoomuch_id_seq advanced to 4653 + sequence tr_etoomuch_id_seq advanced to 4686 + sequence tr_etoomuch_id_seq advanced to 4719 + sequence tr_etoomuch_id_seq advanced to 4752 + sequence tr_etoomuch_id_seq advanced to 4785 + sequence tr_etoomuch_id_seq advanced to 4818 + sequence tr_etoomuch_id_seq advanced to 4851 + sequence tr_etoomuch_id_seq advanced to 4884 + sequence tr_etoomuch_id_seq advanced to 4917 + sequence tr_etoomuch_id_seq advanced to 4950 + sequence tr_etoomuch_id_seq advanced to 4983 + sequence tr_etoomuch_id_seq advanced to 5016 + sequence tr_etoomuch_id_seq advanced to 5049 + sequence tr_etoomuch_id_seq advanced to 5082 + sequence tr_etoomuch_id_seq advanced to 5115 + sequence tr_etoomuch_id_seq advanced to 5148 + sequence tr_etoomuch_id_seq advanced to 5181 + sequence tr_etoomuch_id_seq advanced to 5214 + sequence tr_etoomuch_id_seq advanced to 5247 + sequence tr_etoomuch_id_seq advanced to 5280 + sequence tr_etoomuch_id_seq advanced to 5313 + sequence tr_etoomuch_id_seq advanced to 5346 + sequence tr_etoomuch_id_seq advanced to 5379 + sequence tr_etoomuch_id_seq advanced to 5412 + sequence tr_etoomuch_id_seq advanced to 5445 + sequence tr_etoomuch_id_seq advanced to 5478 + sequence tr_etoomuch_id_seq advanced to 5511 + sequence tr_etoomuch_id_seq advanced to 5544 + sequence tr_etoomuch_id_seq advanced to 5577 + sequence tr_etoomuch_id_seq advanced to 5610 + sequence tr_etoomuch_id_seq advanced to 5643 + sequence tr_etoomuch_id_seq advanced to 5676 + sequence tr_etoomuch_id_seq advanced to 5709 + sequence tr_etoomuch_id_seq advanced to 5742 + sequence tr_etoomuch_id_seq advanced to 5775 + sequence tr_etoomuch_id_seq advanced to 5808 + sequence tr_etoomuch_id_seq advanced to 5841 + sequence tr_etoomuch_id_seq advanced to 5874 + sequence tr_etoomuch_id_seq advanced to 5907 + sequence tr_etoomuch_id_seq advanced to 5940 + sequence tr_etoomuch_id_seq advanced to 5973 + sequence tr_etoomuch_id_seq advanced to 6006 + sequence tr_etoomuch_id_seq advanced to 6039 + sequence tr_etoomuch_id_seq advanced to 6072 + sequence tr_etoomuch_id_seq advanced to 6105 + sequence tr_etoomuch_id_seq advanced to 6138 + sequence tr_etoomuch_id_seq advanced to 6171 + sequence tr_etoomuch_id_seq advanced to 6204 + sequence tr_etoomuch_id_seq advanced to 6237 + sequence tr_etoomuch_id_seq advanced to 6270 + sequence tr_etoomuch_id_seq advanced to 6303 + sequence tr_etoomuch_id_seq advanced to 6336 + sequence tr_etoomuch_id_seq advanced to 6369 + sequence tr_etoomuch_id_seq advanced to 6402 + sequence tr_etoomuch_id_seq advanced to 6435 + sequence tr_etoomuch_id_seq advanced to 6468 + sequence tr_etoomuch_id_seq advanced to 6501 + sequence tr_etoomuch_id_seq advanced to 6534 + sequence tr_etoomuch_id_seq advanced to 6567 + sequence tr_etoomuch_id_seq advanced to 6600 + sequence tr_etoomuch_id_seq advanced to 6633 + sequence tr_etoomuch_id_seq advanced to 6666 + sequence tr_etoomuch_id_seq advanced to 6699 + sequence tr_etoomuch_id_seq advanced to 6732 + sequence tr_etoomuch_id_seq advanced to 6765 + sequence tr_etoomuch_id_seq advanced to 6798 + sequence tr_etoomuch_id_seq advanced to 6831 + sequence tr_etoomuch_id_seq advanced to 6864 + sequence tr_etoomuch_id_seq advanced to 6897 + sequence tr_etoomuch_id_seq advanced to 6930 + sequence tr_etoomuch_id_seq advanced to 6963 + sequence tr_etoomuch_id_seq advanced to 6996 + sequence tr_etoomuch_id_seq advanced to 7029 + sequence tr_etoomuch_id_seq advanced to 7062 + sequence tr_etoomuch_id_seq advanced to 7095 + sequence tr_etoomuch_id_seq advanced to 7128 + sequence tr_etoomuch_id_seq advanced to 7161 + sequence tr_etoomuch_id_seq advanced to 7194 + sequence tr_etoomuch_id_seq advanced to 7227 + sequence tr_etoomuch_id_seq advanced to 7260 + sequence tr_etoomuch_id_seq advanced to 7293 + sequence tr_etoomuch_id_seq advanced to 7326 + sequence tr_etoomuch_id_seq advanced to 7359 + sequence tr_etoomuch_id_seq advanced to 7392 + sequence tr_etoomuch_id_seq advanced to 7425 + sequence tr_etoomuch_id_seq advanced to 7458 + sequence tr_etoomuch_id_seq advanced to 7491 + sequence tr_etoomuch_id_seq advanced to 7524 + sequence tr_etoomuch_id_seq advanced to 7557 + sequence tr_etoomuch_id_seq advanced to 7590 + sequence tr_etoomuch_id_seq advanced to 7623 + sequence tr_etoomuch_id_seq advanced to 7656 + sequence tr_etoomuch_id_seq advanced to 7689 + sequence tr_etoomuch_id_seq advanced to 7722 + sequence tr_etoomuch_id_seq advanced to 7755 + sequence tr_etoomuch_id_seq advanced to 7788 + sequence tr_etoomuch_id_seq advanced to 7821 + sequence tr_etoomuch_id_seq advanced to 7854 + sequence tr_etoomuch_id_seq advanced to 7887 + sequence tr_etoomuch_id_seq advanced to 7920 + sequence tr_etoomuch_id_seq advanced to 7953 + sequence tr_etoomuch_id_seq advanced to 7986 + sequence tr_etoomuch_id_seq advanced to 8019 + sequence tr_etoomuch_id_seq advanced to 8052 + sequence tr_etoomuch_id_seq advanced to 8085 + sequence tr_etoomuch_id_seq advanced to 8118 + sequence tr_etoomuch_id_seq advanced to 8151 + sequence tr_etoomuch_id_seq advanced to 8184 + sequence tr_etoomuch_id_seq advanced to 8217 + sequence tr_etoomuch_id_seq advanced to 8250 + sequence tr_etoomuch_id_seq advanced to 8283 + sequence tr_etoomuch_id_seq advanced to 8316 + sequence tr_etoomuch_id_seq advanced to 8349 + sequence tr_etoomuch_id_seq advanced to 8382 + sequence tr_etoomuch_id_seq advanced to 8415 + sequence tr_etoomuch_id_seq advanced to 8448 + sequence tr_etoomuch_id_seq advanced to 8481 + sequence tr_etoomuch_id_seq advanced to 8514 + sequence tr_etoomuch_id_seq advanced to 8547 + sequence tr_etoomuch_id_seq advanced to 8580 + sequence tr_etoomuch_id_seq advanced to 8613 + sequence tr_etoomuch_id_seq advanced to 8646 + sequence tr_etoomuch_id_seq advanced to 8679 + sequence tr_etoomuch_id_seq advanced to 8712 + sequence tr_etoomuch_id_seq advanced to 8745 + sequence tr_etoomuch_id_seq advanced to 8778 + sequence tr_etoomuch_id_seq advanced to 8811 + sequence tr_etoomuch_id_seq advanced to 8844 + sequence tr_etoomuch_id_seq advanced to 8877 + sequence tr_etoomuch_id_seq advanced to 8910 + sequence tr_etoomuch_id_seq advanced to 8943 + sequence tr_etoomuch_id_seq advanced to 8976 + sequence tr_etoomuch_id_seq advanced to 9009 + sequence tr_etoomuch_id_seq advanced to 9042 + sequence tr_etoomuch_id_seq advanced to 9075 + sequence tr_etoomuch_id_seq advanced to 9108 + sequence tr_etoomuch_id_seq advanced to 9141 + sequence tr_etoomuch_id_seq advanced to 9174 + sequence tr_etoomuch_id_seq advanced to 9207 + sequence tr_etoomuch_id_seq advanced to 9240 + sequence tr_etoomuch_id_seq advanced to 9273 + sequence tr_etoomuch_id_seq advanced to 9306 + sequence tr_etoomuch_id_seq advanced to 9339 + sequence tr_etoomuch_id_seq advanced to 9372 + sequence tr_etoomuch_id_seq advanced to 9405 + sequence tr_etoomuch_id_seq advanced to 9438 + sequence tr_etoomuch_id_seq advanced to 9471 + sequence tr_etoomuch_id_seq advanced to 9504 + sequence tr_etoomuch_id_seq advanced to 9537 + sequence tr_etoomuch_id_seq advanced to 9570 + sequence tr_etoomuch_id_seq advanced to 9603 + sequence tr_etoomuch_id_seq advanced to 9636 + sequence tr_etoomuch_id_seq advanced to 9669 + sequence tr_etoomuch_id_seq advanced to 9702 + sequence tr_etoomuch_id_seq advanced to 9735 + sequence tr_etoomuch_id_seq advanced to 9768 + sequence tr_etoomuch_id_seq advanced to 9801 + sequence tr_etoomuch_id_seq advanced to 9834 + sequence tr_etoomuch_id_seq advanced to 9867 + sequence tr_etoomuch_id_seq advanced to 9900 + sequence tr_etoomuch_id_seq advanced to 9933 + sequence tr_etoomuch_id_seq advanced to 9966 + sequence tr_etoomuch_id_seq advanced to 9999 + sequence tr_etoomuch_id_seq advanced to 10032 + sequence tr_etoomuch_id_seq advanced to 10065 + sequence tr_etoomuch_id_seq advanced to 10098 + sequence tr_etoomuch_id_seq advanced to 10131 + sequence tr_etoomuch_id_seq advanced to 10164 + sequence tr_etoomuch_id_seq advanced to 10197 + sequence tr_etoomuch_id_seq advanced to 10230 + sequence tr_etoomuch_id_seq advanced to 10263 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 33 + sequence replication_metadata_id_seq advanced to 1 + sequence replication_metadata_id_seq advanced to 1 + sequence replication_metadata_id_seq advanced to 33 BEGIN table public.replication_metadata: INSERT: id[integer]:1 relation[name]:'foo' options[text[]]:'{a,b}' COMMIT @@ -460,7 +2114,7 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc BEGIN table public.replication_metadata: INSERT: id[integer]:4 relation[name]:'zaphod' options[text[]]:null rewritemeornot[integer]:null COMMIT -(12 rows) +(340 rows) /* * check whether we handle updates/deletes correct with & without a pkey @@ -536,6 +2190,337 @@ WHERE id = 1; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 33 + sequence tr_etoomuch_id_seq advanced to 66 + sequence tr_etoomuch_id_seq advanced to 99 + sequence tr_etoomuch_id_seq advanced to 132 + sequence tr_etoomuch_id_seq advanced to 165 + sequence tr_etoomuch_id_seq advanced to 198 + sequence tr_etoomuch_id_seq advanced to 231 + sequence tr_etoomuch_id_seq advanced to 264 + sequence tr_etoomuch_id_seq advanced to 297 + sequence tr_etoomuch_id_seq advanced to 330 + sequence tr_etoomuch_id_seq advanced to 363 + sequence tr_etoomuch_id_seq advanced to 396 + sequence tr_etoomuch_id_seq advanced to 429 + sequence tr_etoomuch_id_seq advanced to 462 + sequence tr_etoomuch_id_seq advanced to 495 + sequence tr_etoomuch_id_seq advanced to 528 + sequence tr_etoomuch_id_seq advanced to 561 + sequence tr_etoomuch_id_seq advanced to 594 + sequence tr_etoomuch_id_seq advanced to 627 + sequence tr_etoomuch_id_seq advanced to 660 + sequence tr_etoomuch_id_seq advanced to 693 + sequence tr_etoomuch_id_seq advanced to 726 + sequence tr_etoomuch_id_seq advanced to 759 + sequence tr_etoomuch_id_seq advanced to 792 + sequence tr_etoomuch_id_seq advanced to 825 + sequence tr_etoomuch_id_seq advanced to 858 + sequence tr_etoomuch_id_seq advanced to 891 + sequence tr_etoomuch_id_seq advanced to 924 + sequence tr_etoomuch_id_seq advanced to 957 + sequence tr_etoomuch_id_seq advanced to 990 + sequence tr_etoomuch_id_seq advanced to 1023 + sequence tr_etoomuch_id_seq advanced to 1056 + sequence tr_etoomuch_id_seq advanced to 1089 + sequence tr_etoomuch_id_seq advanced to 1122 + sequence tr_etoomuch_id_seq advanced to 1155 + sequence tr_etoomuch_id_seq advanced to 1188 + sequence tr_etoomuch_id_seq advanced to 1221 + sequence tr_etoomuch_id_seq advanced to 1254 + sequence tr_etoomuch_id_seq advanced to 1287 + sequence tr_etoomuch_id_seq advanced to 1320 + sequence tr_etoomuch_id_seq advanced to 1353 + sequence tr_etoomuch_id_seq advanced to 1386 + sequence tr_etoomuch_id_seq advanced to 1419 + sequence tr_etoomuch_id_seq advanced to 1452 + sequence tr_etoomuch_id_seq advanced to 1485 + sequence tr_etoomuch_id_seq advanced to 1518 + sequence tr_etoomuch_id_seq advanced to 1551 + sequence tr_etoomuch_id_seq advanced to 1584 + sequence tr_etoomuch_id_seq advanced to 1617 + sequence tr_etoomuch_id_seq advanced to 1650 + sequence tr_etoomuch_id_seq advanced to 1683 + sequence tr_etoomuch_id_seq advanced to 1716 + sequence tr_etoomuch_id_seq advanced to 1749 + sequence tr_etoomuch_id_seq advanced to 1782 + sequence tr_etoomuch_id_seq advanced to 1815 + sequence tr_etoomuch_id_seq advanced to 1848 + sequence tr_etoomuch_id_seq advanced to 1881 + sequence tr_etoomuch_id_seq advanced to 1914 + sequence tr_etoomuch_id_seq advanced to 1947 + sequence tr_etoomuch_id_seq advanced to 1980 + sequence tr_etoomuch_id_seq advanced to 2013 + sequence tr_etoomuch_id_seq advanced to 2046 + sequence tr_etoomuch_id_seq advanced to 2079 + sequence tr_etoomuch_id_seq advanced to 2112 + sequence tr_etoomuch_id_seq advanced to 2145 + sequence tr_etoomuch_id_seq advanced to 2178 + sequence tr_etoomuch_id_seq advanced to 2211 + sequence tr_etoomuch_id_seq advanced to 2244 + sequence tr_etoomuch_id_seq advanced to 2277 + sequence tr_etoomuch_id_seq advanced to 2310 + sequence tr_etoomuch_id_seq advanced to 2343 + sequence tr_etoomuch_id_seq advanced to 2376 + sequence tr_etoomuch_id_seq advanced to 2409 + sequence tr_etoomuch_id_seq advanced to 2442 + sequence tr_etoomuch_id_seq advanced to 2475 + sequence tr_etoomuch_id_seq advanced to 2508 + sequence tr_etoomuch_id_seq advanced to 2541 + sequence tr_etoomuch_id_seq advanced to 2574 + sequence tr_etoomuch_id_seq advanced to 2607 + sequence tr_etoomuch_id_seq advanced to 2640 + sequence tr_etoomuch_id_seq advanced to 2673 + sequence tr_etoomuch_id_seq advanced to 2706 + sequence tr_etoomuch_id_seq advanced to 2739 + sequence tr_etoomuch_id_seq advanced to 2772 + sequence tr_etoomuch_id_seq advanced to 2805 + sequence tr_etoomuch_id_seq advanced to 2838 + sequence tr_etoomuch_id_seq advanced to 2871 + sequence tr_etoomuch_id_seq advanced to 2904 + sequence tr_etoomuch_id_seq advanced to 2937 + sequence tr_etoomuch_id_seq advanced to 2970 + sequence tr_etoomuch_id_seq advanced to 3003 + sequence tr_etoomuch_id_seq advanced to 3036 + sequence tr_etoomuch_id_seq advanced to 3069 + sequence tr_etoomuch_id_seq advanced to 3102 + sequence tr_etoomuch_id_seq advanced to 3135 + sequence tr_etoomuch_id_seq advanced to 3168 + sequence tr_etoomuch_id_seq advanced to 3201 + sequence tr_etoomuch_id_seq advanced to 3234 + sequence tr_etoomuch_id_seq advanced to 3267 + sequence tr_etoomuch_id_seq advanced to 3300 + sequence tr_etoomuch_id_seq advanced to 3333 + sequence tr_etoomuch_id_seq advanced to 3366 + sequence tr_etoomuch_id_seq advanced to 3399 + sequence tr_etoomuch_id_seq advanced to 3432 + sequence tr_etoomuch_id_seq advanced to 3465 + sequence tr_etoomuch_id_seq advanced to 3498 + sequence tr_etoomuch_id_seq advanced to 3531 + sequence tr_etoomuch_id_seq advanced to 3564 + sequence tr_etoomuch_id_seq advanced to 3597 + sequence tr_etoomuch_id_seq advanced to 3630 + sequence tr_etoomuch_id_seq advanced to 3663 + sequence tr_etoomuch_id_seq advanced to 3696 + sequence tr_etoomuch_id_seq advanced to 3729 + sequence tr_etoomuch_id_seq advanced to 3762 + sequence tr_etoomuch_id_seq advanced to 3795 + sequence tr_etoomuch_id_seq advanced to 3828 + sequence tr_etoomuch_id_seq advanced to 3861 + sequence tr_etoomuch_id_seq advanced to 3894 + sequence tr_etoomuch_id_seq advanced to 3927 + sequence tr_etoomuch_id_seq advanced to 3960 + sequence tr_etoomuch_id_seq advanced to 3993 + sequence tr_etoomuch_id_seq advanced to 4026 + sequence tr_etoomuch_id_seq advanced to 4059 + sequence tr_etoomuch_id_seq advanced to 4092 + sequence tr_etoomuch_id_seq advanced to 4125 + sequence tr_etoomuch_id_seq advanced to 4158 + sequence tr_etoomuch_id_seq advanced to 4191 + sequence tr_etoomuch_id_seq advanced to 4224 + sequence tr_etoomuch_id_seq advanced to 4257 + sequence tr_etoomuch_id_seq advanced to 4290 + sequence tr_etoomuch_id_seq advanced to 4323 + sequence tr_etoomuch_id_seq advanced to 4356 + sequence tr_etoomuch_id_seq advanced to 4389 + sequence tr_etoomuch_id_seq advanced to 4422 + sequence tr_etoomuch_id_seq advanced to 4455 + sequence tr_etoomuch_id_seq advanced to 4488 + sequence tr_etoomuch_id_seq advanced to 4521 + sequence tr_etoomuch_id_seq advanced to 4554 + sequence tr_etoomuch_id_seq advanced to 4587 + sequence tr_etoomuch_id_seq advanced to 4620 + sequence tr_etoomuch_id_seq advanced to 4653 + sequence tr_etoomuch_id_seq advanced to 4686 + sequence tr_etoomuch_id_seq advanced to 4719 + sequence tr_etoomuch_id_seq advanced to 4752 + sequence tr_etoomuch_id_seq advanced to 4785 + sequence tr_etoomuch_id_seq advanced to 4818 + sequence tr_etoomuch_id_seq advanced to 4851 + sequence tr_etoomuch_id_seq advanced to 4884 + sequence tr_etoomuch_id_seq advanced to 4917 + sequence tr_etoomuch_id_seq advanced to 4950 + sequence tr_etoomuch_id_seq advanced to 4983 + sequence tr_etoomuch_id_seq advanced to 5016 + sequence tr_etoomuch_id_seq advanced to 5049 + sequence tr_etoomuch_id_seq advanced to 5082 + sequence tr_etoomuch_id_seq advanced to 5115 + sequence tr_etoomuch_id_seq advanced to 5148 + sequence tr_etoomuch_id_seq advanced to 5181 + sequence tr_etoomuch_id_seq advanced to 5214 + sequence tr_etoomuch_id_seq advanced to 5247 + sequence tr_etoomuch_id_seq advanced to 5280 + sequence tr_etoomuch_id_seq advanced to 5313 + sequence tr_etoomuch_id_seq advanced to 5346 + sequence tr_etoomuch_id_seq advanced to 5379 + sequence tr_etoomuch_id_seq advanced to 5412 + sequence tr_etoomuch_id_seq advanced to 5445 + sequence tr_etoomuch_id_seq advanced to 5478 + sequence tr_etoomuch_id_seq advanced to 5511 + sequence tr_etoomuch_id_seq advanced to 5544 + sequence tr_etoomuch_id_seq advanced to 5577 + sequence tr_etoomuch_id_seq advanced to 5610 + sequence tr_etoomuch_id_seq advanced to 5643 + sequence tr_etoomuch_id_seq advanced to 5676 + sequence tr_etoomuch_id_seq advanced to 5709 + sequence tr_etoomuch_id_seq advanced to 5742 + sequence tr_etoomuch_id_seq advanced to 5775 + sequence tr_etoomuch_id_seq advanced to 5808 + sequence tr_etoomuch_id_seq advanced to 5841 + sequence tr_etoomuch_id_seq advanced to 5874 + sequence tr_etoomuch_id_seq advanced to 5907 + sequence tr_etoomuch_id_seq advanced to 5940 + sequence tr_etoomuch_id_seq advanced to 5973 + sequence tr_etoomuch_id_seq advanced to 6006 + sequence tr_etoomuch_id_seq advanced to 6039 + sequence tr_etoomuch_id_seq advanced to 6072 + sequence tr_etoomuch_id_seq advanced to 6105 + sequence tr_etoomuch_id_seq advanced to 6138 + sequence tr_etoomuch_id_seq advanced to 6171 + sequence tr_etoomuch_id_seq advanced to 6204 + sequence tr_etoomuch_id_seq advanced to 6237 + sequence tr_etoomuch_id_seq advanced to 6270 + sequence tr_etoomuch_id_seq advanced to 6303 + sequence tr_etoomuch_id_seq advanced to 6336 + sequence tr_etoomuch_id_seq advanced to 6369 + sequence tr_etoomuch_id_seq advanced to 6402 + sequence tr_etoomuch_id_seq advanced to 6435 + sequence tr_etoomuch_id_seq advanced to 6468 + sequence tr_etoomuch_id_seq advanced to 6501 + sequence tr_etoomuch_id_seq advanced to 6534 + sequence tr_etoomuch_id_seq advanced to 6567 + sequence tr_etoomuch_id_seq advanced to 6600 + sequence tr_etoomuch_id_seq advanced to 6633 + sequence tr_etoomuch_id_seq advanced to 6666 + sequence tr_etoomuch_id_seq advanced to 6699 + sequence tr_etoomuch_id_seq advanced to 6732 + sequence tr_etoomuch_id_seq advanced to 6765 + sequence tr_etoomuch_id_seq advanced to 6798 + sequence tr_etoomuch_id_seq advanced to 6831 + sequence tr_etoomuch_id_seq advanced to 6864 + sequence tr_etoomuch_id_seq advanced to 6897 + sequence tr_etoomuch_id_seq advanced to 6930 + sequence tr_etoomuch_id_seq advanced to 6963 + sequence tr_etoomuch_id_seq advanced to 6996 + sequence tr_etoomuch_id_seq advanced to 7029 + sequence tr_etoomuch_id_seq advanced to 7062 + sequence tr_etoomuch_id_seq advanced to 7095 + sequence tr_etoomuch_id_seq advanced to 7128 + sequence tr_etoomuch_id_seq advanced to 7161 + sequence tr_etoomuch_id_seq advanced to 7194 + sequence tr_etoomuch_id_seq advanced to 7227 + sequence tr_etoomuch_id_seq advanced to 7260 + sequence tr_etoomuch_id_seq advanced to 7293 + sequence tr_etoomuch_id_seq advanced to 7326 + sequence tr_etoomuch_id_seq advanced to 7359 + sequence tr_etoomuch_id_seq advanced to 7392 + sequence tr_etoomuch_id_seq advanced to 7425 + sequence tr_etoomuch_id_seq advanced to 7458 + sequence tr_etoomuch_id_seq advanced to 7491 + sequence tr_etoomuch_id_seq advanced to 7524 + sequence tr_etoomuch_id_seq advanced to 7557 + sequence tr_etoomuch_id_seq advanced to 7590 + sequence tr_etoomuch_id_seq advanced to 7623 + sequence tr_etoomuch_id_seq advanced to 7656 + sequence tr_etoomuch_id_seq advanced to 7689 + sequence tr_etoomuch_id_seq advanced to 7722 + sequence tr_etoomuch_id_seq advanced to 7755 + sequence tr_etoomuch_id_seq advanced to 7788 + sequence tr_etoomuch_id_seq advanced to 7821 + sequence tr_etoomuch_id_seq advanced to 7854 + sequence tr_etoomuch_id_seq advanced to 7887 + sequence tr_etoomuch_id_seq advanced to 7920 + sequence tr_etoomuch_id_seq advanced to 7953 + sequence tr_etoomuch_id_seq advanced to 7986 + sequence tr_etoomuch_id_seq advanced to 8019 + sequence tr_etoomuch_id_seq advanced to 8052 + sequence tr_etoomuch_id_seq advanced to 8085 + sequence tr_etoomuch_id_seq advanced to 8118 + sequence tr_etoomuch_id_seq advanced to 8151 + sequence tr_etoomuch_id_seq advanced to 8184 + sequence tr_etoomuch_id_seq advanced to 8217 + sequence tr_etoomuch_id_seq advanced to 8250 + sequence tr_etoomuch_id_seq advanced to 8283 + sequence tr_etoomuch_id_seq advanced to 8316 + sequence tr_etoomuch_id_seq advanced to 8349 + sequence tr_etoomuch_id_seq advanced to 8382 + sequence tr_etoomuch_id_seq advanced to 8415 + sequence tr_etoomuch_id_seq advanced to 8448 + sequence tr_etoomuch_id_seq advanced to 8481 + sequence tr_etoomuch_id_seq advanced to 8514 + sequence tr_etoomuch_id_seq advanced to 8547 + sequence tr_etoomuch_id_seq advanced to 8580 + sequence tr_etoomuch_id_seq advanced to 8613 + sequence tr_etoomuch_id_seq advanced to 8646 + sequence tr_etoomuch_id_seq advanced to 8679 + sequence tr_etoomuch_id_seq advanced to 8712 + sequence tr_etoomuch_id_seq advanced to 8745 + sequence tr_etoomuch_id_seq advanced to 8778 + sequence tr_etoomuch_id_seq advanced to 8811 + sequence tr_etoomuch_id_seq advanced to 8844 + sequence tr_etoomuch_id_seq advanced to 8877 + sequence tr_etoomuch_id_seq advanced to 8910 + sequence tr_etoomuch_id_seq advanced to 8943 + sequence tr_etoomuch_id_seq advanced to 8976 + sequence tr_etoomuch_id_seq advanced to 9009 + sequence tr_etoomuch_id_seq advanced to 9042 + sequence tr_etoomuch_id_seq advanced to 9075 + sequence tr_etoomuch_id_seq advanced to 9108 + sequence tr_etoomuch_id_seq advanced to 9141 + sequence tr_etoomuch_id_seq advanced to 9174 + sequence tr_etoomuch_id_seq advanced to 9207 + sequence tr_etoomuch_id_seq advanced to 9240 + sequence tr_etoomuch_id_seq advanced to 9273 + sequence tr_etoomuch_id_seq advanced to 9306 + sequence tr_etoomuch_id_seq advanced to 9339 + sequence tr_etoomuch_id_seq advanced to 9372 + sequence tr_etoomuch_id_seq advanced to 9405 + sequence tr_etoomuch_id_seq advanced to 9438 + sequence tr_etoomuch_id_seq advanced to 9471 + sequence tr_etoomuch_id_seq advanced to 9504 + sequence tr_etoomuch_id_seq advanced to 9537 + sequence tr_etoomuch_id_seq advanced to 9570 + sequence tr_etoomuch_id_seq advanced to 9603 + sequence tr_etoomuch_id_seq advanced to 9636 + sequence tr_etoomuch_id_seq advanced to 9669 + sequence tr_etoomuch_id_seq advanced to 9702 + sequence tr_etoomuch_id_seq advanced to 9735 + sequence tr_etoomuch_id_seq advanced to 9768 + sequence tr_etoomuch_id_seq advanced to 9801 + sequence tr_etoomuch_id_seq advanced to 9834 + sequence tr_etoomuch_id_seq advanced to 9867 + sequence tr_etoomuch_id_seq advanced to 9900 + sequence tr_etoomuch_id_seq advanced to 9933 + sequence tr_etoomuch_id_seq advanced to 9966 + sequence tr_etoomuch_id_seq advanced to 9999 + sequence tr_etoomuch_id_seq advanced to 10032 + sequence tr_etoomuch_id_seq advanced to 10065 + sequence tr_etoomuch_id_seq advanced to 10098 + sequence tr_etoomuch_id_seq advanced to 10131 + sequence tr_etoomuch_id_seq advanced to 10164 + sequence tr_etoomuch_id_seq advanced to 10197 + sequence tr_etoomuch_id_seq advanced to 10230 + sequence tr_etoomuch_id_seq advanced to 10263 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 33 + sequence replication_metadata_id_seq advanced to 1 + sequence replication_metadata_id_seq advanced to 1 + sequence replication_metadata_id_seq advanced to 33 + sequence table_without_key_id_seq advanced to 1 + sequence table_without_key_id_seq advanced to 1 + sequence table_without_key_id_seq advanced to 33 BEGIN table public.table_without_key: INSERT: id[integer]:1 data[integer]:1 table public.table_without_key: INSERT: id[integer]:2 data[integer]:2 @@ -567,6 +2552,9 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc BEGIN table public.table_without_key: DELETE: id[integer]:2 data[integer]:3 new_column[text]:'someval' COMMIT + sequence table_with_pkey_id_seq advanced to 1 + sequence table_with_pkey_id_seq advanced to 1 + sequence table_with_pkey_id_seq advanced to 33 BEGIN table public.table_with_pkey: INSERT: id[integer]:1 data[integer]:1 table public.table_with_pkey: INSERT: id[integer]:2 data[integer]:2 @@ -592,6 +2580,9 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc BEGIN table public.table_with_pkey: DELETE: id[integer]:2 COMMIT + sequence table_with_unique_not_null_id_seq advanced to 1 + sequence table_with_unique_not_null_id_seq advanced to 1 + sequence table_with_unique_not_null_id_seq advanced to 33 BEGIN table public.table_with_unique_not_null: INSERT: id[integer]:1 data[integer]:1 table public.table_with_unique_not_null: INSERT: id[integer]:2 data[integer]:2 @@ -630,6 +2621,11 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc BEGIN table public.table_with_unique_not_null: DELETE: id[integer]:4 COMMIT + sequence toasttable_rand_seq advanced to 79 + sequence toasttable_id_seq advanced to 1 + sequence toasttable_id_seq advanced to 1 + sequence toasttable_id_seq advanced to 33 + sequence toasttable_rand_seq advanced to 48047 BEGIN table public.toasttable: INSERT: id[integer]:1 toasted_col1[text]:'12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000' rand1[double precision]:79 toasted_col2[text]:null rand2[double precision]:1578 COMMIT @@ -639,7 +2635,7 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc BEGIN table public.toasttable: UPDATE: id[integer]:1 toasted_col1[text]:'12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000' rand1[double precision]:79 toasted_col2[text]:null rand2[double precision]:1578 COMMIT -(103 rows) +(445 rows) INSERT INTO toasttable(toasted_col1) SELECT string_agg(g.i::text, '') FROM generate_series(1, 2000) g(i); -- update of second column, first column unchanged @@ -651,19 +2647,703 @@ DROP TABLE toasttable; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 33 + sequence tr_etoomuch_id_seq advanced to 66 + sequence tr_etoomuch_id_seq advanced to 99 + sequence tr_etoomuch_id_seq advanced to 132 + sequence tr_etoomuch_id_seq advanced to 165 + sequence tr_etoomuch_id_seq advanced to 198 + sequence tr_etoomuch_id_seq advanced to 231 + sequence tr_etoomuch_id_seq advanced to 264 + sequence tr_etoomuch_id_seq advanced to 297 + sequence tr_etoomuch_id_seq advanced to 330 + sequence tr_etoomuch_id_seq advanced to 363 + sequence tr_etoomuch_id_seq advanced to 396 + sequence tr_etoomuch_id_seq advanced to 429 + sequence tr_etoomuch_id_seq advanced to 462 + sequence tr_etoomuch_id_seq advanced to 495 + sequence tr_etoomuch_id_seq advanced to 528 + sequence tr_etoomuch_id_seq advanced to 561 + sequence tr_etoomuch_id_seq advanced to 594 + sequence tr_etoomuch_id_seq advanced to 627 + sequence tr_etoomuch_id_seq advanced to 660 + sequence tr_etoomuch_id_seq advanced to 693 + sequence tr_etoomuch_id_seq advanced to 726 + sequence tr_etoomuch_id_seq advanced to 759 + sequence tr_etoomuch_id_seq advanced to 792 + sequence tr_etoomuch_id_seq advanced to 825 + sequence tr_etoomuch_id_seq advanced to 858 + sequence tr_etoomuch_id_seq advanced to 891 + sequence tr_etoomuch_id_seq advanced to 924 + sequence tr_etoomuch_id_seq advanced to 957 + sequence tr_etoomuch_id_seq advanced to 990 + sequence tr_etoomuch_id_seq advanced to 1023 + sequence tr_etoomuch_id_seq advanced to 1056 + sequence tr_etoomuch_id_seq advanced to 1089 + sequence tr_etoomuch_id_seq advanced to 1122 + sequence tr_etoomuch_id_seq advanced to 1155 + sequence tr_etoomuch_id_seq advanced to 1188 + sequence tr_etoomuch_id_seq advanced to 1221 + sequence tr_etoomuch_id_seq advanced to 1254 + sequence tr_etoomuch_id_seq advanced to 1287 + sequence tr_etoomuch_id_seq advanced to 1320 + sequence tr_etoomuch_id_seq advanced to 1353 + sequence tr_etoomuch_id_seq advanced to 1386 + sequence tr_etoomuch_id_seq advanced to 1419 + sequence tr_etoomuch_id_seq advanced to 1452 + sequence tr_etoomuch_id_seq advanced to 1485 + sequence tr_etoomuch_id_seq advanced to 1518 + sequence tr_etoomuch_id_seq advanced to 1551 + sequence tr_etoomuch_id_seq advanced to 1584 + sequence tr_etoomuch_id_seq advanced to 1617 + sequence tr_etoomuch_id_seq advanced to 1650 + sequence tr_etoomuch_id_seq advanced to 1683 + sequence tr_etoomuch_id_seq advanced to 1716 + sequence tr_etoomuch_id_seq advanced to 1749 + sequence tr_etoomuch_id_seq advanced to 1782 + sequence tr_etoomuch_id_seq advanced to 1815 + sequence tr_etoomuch_id_seq advanced to 1848 + sequence tr_etoomuch_id_seq advanced to 1881 + sequence tr_etoomuch_id_seq advanced to 1914 + sequence tr_etoomuch_id_seq advanced to 1947 + sequence tr_etoomuch_id_seq advanced to 1980 + sequence tr_etoomuch_id_seq advanced to 2013 + sequence tr_etoomuch_id_seq advanced to 2046 + sequence tr_etoomuch_id_seq advanced to 2079 + sequence tr_etoomuch_id_seq advanced to 2112 + sequence tr_etoomuch_id_seq advanced to 2145 + sequence tr_etoomuch_id_seq advanced to 2178 + sequence tr_etoomuch_id_seq advanced to 2211 + sequence tr_etoomuch_id_seq advanced to 2244 + sequence tr_etoomuch_id_seq advanced to 2277 + sequence tr_etoomuch_id_seq advanced to 2310 + sequence tr_etoomuch_id_seq advanced to 2343 + sequence tr_etoomuch_id_seq advanced to 2376 + sequence tr_etoomuch_id_seq advanced to 2409 + sequence tr_etoomuch_id_seq advanced to 2442 + sequence tr_etoomuch_id_seq advanced to 2475 + sequence tr_etoomuch_id_seq advanced to 2508 + sequence tr_etoomuch_id_seq advanced to 2541 + sequence tr_etoomuch_id_seq advanced to 2574 + sequence tr_etoomuch_id_seq advanced to 2607 + sequence tr_etoomuch_id_seq advanced to 2640 + sequence tr_etoomuch_id_seq advanced to 2673 + sequence tr_etoomuch_id_seq advanced to 2706 + sequence tr_etoomuch_id_seq advanced to 2739 + sequence tr_etoomuch_id_seq advanced to 2772 + sequence tr_etoomuch_id_seq advanced to 2805 + sequence tr_etoomuch_id_seq advanced to 2838 + sequence tr_etoomuch_id_seq advanced to 2871 + sequence tr_etoomuch_id_seq advanced to 2904 + sequence tr_etoomuch_id_seq advanced to 2937 + sequence tr_etoomuch_id_seq advanced to 2970 + sequence tr_etoomuch_id_seq advanced to 3003 + sequence tr_etoomuch_id_seq advanced to 3036 + sequence tr_etoomuch_id_seq advanced to 3069 + sequence tr_etoomuch_id_seq advanced to 3102 + sequence tr_etoomuch_id_seq advanced to 3135 + sequence tr_etoomuch_id_seq advanced to 3168 + sequence tr_etoomuch_id_seq advanced to 3201 + sequence tr_etoomuch_id_seq advanced to 3234 + sequence tr_etoomuch_id_seq advanced to 3267 + sequence tr_etoomuch_id_seq advanced to 3300 + sequence tr_etoomuch_id_seq advanced to 3333 + sequence tr_etoomuch_id_seq advanced to 3366 + sequence tr_etoomuch_id_seq advanced to 3399 + sequence tr_etoomuch_id_seq advanced to 3432 + sequence tr_etoomuch_id_seq advanced to 3465 + sequence tr_etoomuch_id_seq advanced to 3498 + sequence tr_etoomuch_id_seq advanced to 3531 + sequence tr_etoomuch_id_seq advanced to 3564 + sequence tr_etoomuch_id_seq advanced to 3597 + sequence tr_etoomuch_id_seq advanced to 3630 + sequence tr_etoomuch_id_seq advanced to 3663 + sequence tr_etoomuch_id_seq advanced to 3696 + sequence tr_etoomuch_id_seq advanced to 3729 + sequence tr_etoomuch_id_seq advanced to 3762 + sequence tr_etoomuch_id_seq advanced to 3795 + sequence tr_etoomuch_id_seq advanced to 3828 + sequence tr_etoomuch_id_seq advanced to 3861 + sequence tr_etoomuch_id_seq advanced to 3894 + sequence tr_etoomuch_id_seq advanced to 3927 + sequence tr_etoomuch_id_seq advanced to 3960 + sequence tr_etoomuch_id_seq advanced to 3993 + sequence tr_etoomuch_id_seq advanced to 4026 + sequence tr_etoomuch_id_seq advanced to 4059 + sequence tr_etoomuch_id_seq advanced to 4092 + sequence tr_etoomuch_id_seq advanced to 4125 + sequence tr_etoomuch_id_seq advanced to 4158 + sequence tr_etoomuch_id_seq advanced to 4191 + sequence tr_etoomuch_id_seq advanced to 4224 + sequence tr_etoomuch_id_seq advanced to 4257 + sequence tr_etoomuch_id_seq advanced to 4290 + sequence tr_etoomuch_id_seq advanced to 4323 + sequence tr_etoomuch_id_seq advanced to 4356 + sequence tr_etoomuch_id_seq advanced to 4389 + sequence tr_etoomuch_id_seq advanced to 4422 + sequence tr_etoomuch_id_seq advanced to 4455 + sequence tr_etoomuch_id_seq advanced to 4488 + sequence tr_etoomuch_id_seq advanced to 4521 + sequence tr_etoomuch_id_seq advanced to 4554 + sequence tr_etoomuch_id_seq advanced to 4587 + sequence tr_etoomuch_id_seq advanced to 4620 + sequence tr_etoomuch_id_seq advanced to 4653 + sequence tr_etoomuch_id_seq advanced to 4686 + sequence tr_etoomuch_id_seq advanced to 4719 + sequence tr_etoomuch_id_seq advanced to 4752 + sequence tr_etoomuch_id_seq advanced to 4785 + sequence tr_etoomuch_id_seq advanced to 4818 + sequence tr_etoomuch_id_seq advanced to 4851 + sequence tr_etoomuch_id_seq advanced to 4884 + sequence tr_etoomuch_id_seq advanced to 4917 + sequence tr_etoomuch_id_seq advanced to 4950 + sequence tr_etoomuch_id_seq advanced to 4983 + sequence tr_etoomuch_id_seq advanced to 5016 + sequence tr_etoomuch_id_seq advanced to 5049 + sequence tr_etoomuch_id_seq advanced to 5082 + sequence tr_etoomuch_id_seq advanced to 5115 + sequence tr_etoomuch_id_seq advanced to 5148 + sequence tr_etoomuch_id_seq advanced to 5181 + sequence tr_etoomuch_id_seq advanced to 5214 + sequence tr_etoomuch_id_seq advanced to 5247 + sequence tr_etoomuch_id_seq advanced to 5280 + sequence tr_etoomuch_id_seq advanced to 5313 + sequence tr_etoomuch_id_seq advanced to 5346 + sequence tr_etoomuch_id_seq advanced to 5379 + sequence tr_etoomuch_id_seq advanced to 5412 + sequence tr_etoomuch_id_seq advanced to 5445 + sequence tr_etoomuch_id_seq advanced to 5478 + sequence tr_etoomuch_id_seq advanced to 5511 + sequence tr_etoomuch_id_seq advanced to 5544 + sequence tr_etoomuch_id_seq advanced to 5577 + sequence tr_etoomuch_id_seq advanced to 5610 + sequence tr_etoomuch_id_seq advanced to 5643 + sequence tr_etoomuch_id_seq advanced to 5676 + sequence tr_etoomuch_id_seq advanced to 5709 + sequence tr_etoomuch_id_seq advanced to 5742 + sequence tr_etoomuch_id_seq advanced to 5775 + sequence tr_etoomuch_id_seq advanced to 5808 + sequence tr_etoomuch_id_seq advanced to 5841 + sequence tr_etoomuch_id_seq advanced to 5874 + sequence tr_etoomuch_id_seq advanced to 5907 + sequence tr_etoomuch_id_seq advanced to 5940 + sequence tr_etoomuch_id_seq advanced to 5973 + sequence tr_etoomuch_id_seq advanced to 6006 + sequence tr_etoomuch_id_seq advanced to 6039 + sequence tr_etoomuch_id_seq advanced to 6072 + sequence tr_etoomuch_id_seq advanced to 6105 + sequence tr_etoomuch_id_seq advanced to 6138 + sequence tr_etoomuch_id_seq advanced to 6171 + sequence tr_etoomuch_id_seq advanced to 6204 + sequence tr_etoomuch_id_seq advanced to 6237 + sequence tr_etoomuch_id_seq advanced to 6270 + sequence tr_etoomuch_id_seq advanced to 6303 + sequence tr_etoomuch_id_seq advanced to 6336 + sequence tr_etoomuch_id_seq advanced to 6369 + sequence tr_etoomuch_id_seq advanced to 6402 + sequence tr_etoomuch_id_seq advanced to 6435 + sequence tr_etoomuch_id_seq advanced to 6468 + sequence tr_etoomuch_id_seq advanced to 6501 + sequence tr_etoomuch_id_seq advanced to 6534 + sequence tr_etoomuch_id_seq advanced to 6567 + sequence tr_etoomuch_id_seq advanced to 6600 + sequence tr_etoomuch_id_seq advanced to 6633 + sequence tr_etoomuch_id_seq advanced to 6666 + sequence tr_etoomuch_id_seq advanced to 6699 + sequence tr_etoomuch_id_seq advanced to 6732 + sequence tr_etoomuch_id_seq advanced to 6765 + sequence tr_etoomuch_id_seq advanced to 6798 + sequence tr_etoomuch_id_seq advanced to 6831 + sequence tr_etoomuch_id_seq advanced to 6864 + sequence tr_etoomuch_id_seq advanced to 6897 + sequence tr_etoomuch_id_seq advanced to 6930 + sequence tr_etoomuch_id_seq advanced to 6963 + sequence tr_etoomuch_id_seq advanced to 6996 + sequence tr_etoomuch_id_seq advanced to 7029 + sequence tr_etoomuch_id_seq advanced to 7062 + sequence tr_etoomuch_id_seq advanced to 7095 + sequence tr_etoomuch_id_seq advanced to 7128 + sequence tr_etoomuch_id_seq advanced to 7161 + sequence tr_etoomuch_id_seq advanced to 7194 + sequence tr_etoomuch_id_seq advanced to 7227 + sequence tr_etoomuch_id_seq advanced to 7260 + sequence tr_etoomuch_id_seq advanced to 7293 + sequence tr_etoomuch_id_seq advanced to 7326 + sequence tr_etoomuch_id_seq advanced to 7359 + sequence tr_etoomuch_id_seq advanced to 7392 + sequence tr_etoomuch_id_seq advanced to 7425 + sequence tr_etoomuch_id_seq advanced to 7458 + sequence tr_etoomuch_id_seq advanced to 7491 + sequence tr_etoomuch_id_seq advanced to 7524 + sequence tr_etoomuch_id_seq advanced to 7557 + sequence tr_etoomuch_id_seq advanced to 7590 + sequence tr_etoomuch_id_seq advanced to 7623 + sequence tr_etoomuch_id_seq advanced to 7656 + sequence tr_etoomuch_id_seq advanced to 7689 + sequence tr_etoomuch_id_seq advanced to 7722 + sequence tr_etoomuch_id_seq advanced to 7755 + sequence tr_etoomuch_id_seq advanced to 7788 + sequence tr_etoomuch_id_seq advanced to 7821 + sequence tr_etoomuch_id_seq advanced to 7854 + sequence tr_etoomuch_id_seq advanced to 7887 + sequence tr_etoomuch_id_seq advanced to 7920 + sequence tr_etoomuch_id_seq advanced to 7953 + sequence tr_etoomuch_id_seq advanced to 7986 + sequence tr_etoomuch_id_seq advanced to 8019 + sequence tr_etoomuch_id_seq advanced to 8052 + sequence tr_etoomuch_id_seq advanced to 8085 + sequence tr_etoomuch_id_seq advanced to 8118 + sequence tr_etoomuch_id_seq advanced to 8151 + sequence tr_etoomuch_id_seq advanced to 8184 + sequence tr_etoomuch_id_seq advanced to 8217 + sequence tr_etoomuch_id_seq advanced to 8250 + sequence tr_etoomuch_id_seq advanced to 8283 + sequence tr_etoomuch_id_seq advanced to 8316 + sequence tr_etoomuch_id_seq advanced to 8349 + sequence tr_etoomuch_id_seq advanced to 8382 + sequence tr_etoomuch_id_seq advanced to 8415 + sequence tr_etoomuch_id_seq advanced to 8448 + sequence tr_etoomuch_id_seq advanced to 8481 + sequence tr_etoomuch_id_seq advanced to 8514 + sequence tr_etoomuch_id_seq advanced to 8547 + sequence tr_etoomuch_id_seq advanced to 8580 + sequence tr_etoomuch_id_seq advanced to 8613 + sequence tr_etoomuch_id_seq advanced to 8646 + sequence tr_etoomuch_id_seq advanced to 8679 + sequence tr_etoomuch_id_seq advanced to 8712 + sequence tr_etoomuch_id_seq advanced to 8745 + sequence tr_etoomuch_id_seq advanced to 8778 + sequence tr_etoomuch_id_seq advanced to 8811 + sequence tr_etoomuch_id_seq advanced to 8844 + sequence tr_etoomuch_id_seq advanced to 8877 + sequence tr_etoomuch_id_seq advanced to 8910 + sequence tr_etoomuch_id_seq advanced to 8943 + sequence tr_etoomuch_id_seq advanced to 8976 + sequence tr_etoomuch_id_seq advanced to 9009 + sequence tr_etoomuch_id_seq advanced to 9042 + sequence tr_etoomuch_id_seq advanced to 9075 + sequence tr_etoomuch_id_seq advanced to 9108 + sequence tr_etoomuch_id_seq advanced to 9141 + sequence tr_etoomuch_id_seq advanced to 9174 + sequence tr_etoomuch_id_seq advanced to 9207 + sequence tr_etoomuch_id_seq advanced to 9240 + sequence tr_etoomuch_id_seq advanced to 9273 + sequence tr_etoomuch_id_seq advanced to 9306 + sequence tr_etoomuch_id_seq advanced to 9339 + sequence tr_etoomuch_id_seq advanced to 9372 + sequence tr_etoomuch_id_seq advanced to 9405 + sequence tr_etoomuch_id_seq advanced to 9438 + sequence tr_etoomuch_id_seq advanced to 9471 + sequence tr_etoomuch_id_seq advanced to 9504 + sequence tr_etoomuch_id_seq advanced to 9537 + sequence tr_etoomuch_id_seq advanced to 9570 + sequence tr_etoomuch_id_seq advanced to 9603 + sequence tr_etoomuch_id_seq advanced to 9636 + sequence tr_etoomuch_id_seq advanced to 9669 + sequence tr_etoomuch_id_seq advanced to 9702 + sequence tr_etoomuch_id_seq advanced to 9735 + sequence tr_etoomuch_id_seq advanced to 9768 + sequence tr_etoomuch_id_seq advanced to 9801 + sequence tr_etoomuch_id_seq advanced to 9834 + sequence tr_etoomuch_id_seq advanced to 9867 + sequence tr_etoomuch_id_seq advanced to 9900 + sequence tr_etoomuch_id_seq advanced to 9933 + sequence tr_etoomuch_id_seq advanced to 9966 + sequence tr_etoomuch_id_seq advanced to 9999 + sequence tr_etoomuch_id_seq advanced to 10032 + sequence tr_etoomuch_id_seq advanced to 10065 + sequence tr_etoomuch_id_seq advanced to 10098 + sequence tr_etoomuch_id_seq advanced to 10131 + sequence tr_etoomuch_id_seq advanced to 10164 + sequence tr_etoomuch_id_seq advanced to 10197 + sequence tr_etoomuch_id_seq advanced to 10230 + sequence tr_etoomuch_id_seq advanced to 10263 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 33 + sequence replication_metadata_id_seq advanced to 1 + sequence replication_metadata_id_seq advanced to 1 + sequence replication_metadata_id_seq advanced to 33 + sequence table_without_key_id_seq advanced to 1 + sequence table_without_key_id_seq advanced to 1 + sequence table_without_key_id_seq advanced to 33 + sequence table_with_pkey_id_seq advanced to 1 + sequence table_with_pkey_id_seq advanced to 1 + sequence table_with_pkey_id_seq advanced to 33 + sequence table_with_unique_not_null_id_seq advanced to 1 + sequence table_with_unique_not_null_id_seq advanced to 1 + sequence table_with_unique_not_null_id_seq advanced to 33 + sequence toasttable_rand_seq advanced to 79 + sequence toasttable_id_seq advanced to 1 + sequence toasttable_id_seq advanced to 1 + sequence toasttable_id_seq advanced to 33 + sequence toasttable_rand_seq advanced to 48047 BEGIN table public.toasttable: INSERT: id[integer]:3 toasted_col1[text]:'12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000' rand1[double precision]:6075 toasted_col2[text]:null rand2[double precision]:7574 COMMIT BEGIN table public.toasttable: UPDATE: id[integer]:1 toasted_col1[text]:unchanged-toast-datum rand1[double precision]:79 toasted_col2[text]:'12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000' rand2[double precision]:1578 COMMIT -(6 rows) +(348 rows) -- done, free logical replication slot SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); - data ------- -(0 rows) + data +----------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 1 + sequence tr_unique_id2_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_pkey_id_seq advanced to 33 + sequence tr_pkey_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 1 + sequence tr_etoomuch_id_seq advanced to 33 + sequence tr_etoomuch_id_seq advanced to 66 + sequence tr_etoomuch_id_seq advanced to 99 + sequence tr_etoomuch_id_seq advanced to 132 + sequence tr_etoomuch_id_seq advanced to 165 + sequence tr_etoomuch_id_seq advanced to 198 + sequence tr_etoomuch_id_seq advanced to 231 + sequence tr_etoomuch_id_seq advanced to 264 + sequence tr_etoomuch_id_seq advanced to 297 + sequence tr_etoomuch_id_seq advanced to 330 + sequence tr_etoomuch_id_seq advanced to 363 + sequence tr_etoomuch_id_seq advanced to 396 + sequence tr_etoomuch_id_seq advanced to 429 + sequence tr_etoomuch_id_seq advanced to 462 + sequence tr_etoomuch_id_seq advanced to 495 + sequence tr_etoomuch_id_seq advanced to 528 + sequence tr_etoomuch_id_seq advanced to 561 + sequence tr_etoomuch_id_seq advanced to 594 + sequence tr_etoomuch_id_seq advanced to 627 + sequence tr_etoomuch_id_seq advanced to 660 + sequence tr_etoomuch_id_seq advanced to 693 + sequence tr_etoomuch_id_seq advanced to 726 + sequence tr_etoomuch_id_seq advanced to 759 + sequence tr_etoomuch_id_seq advanced to 792 + sequence tr_etoomuch_id_seq advanced to 825 + sequence tr_etoomuch_id_seq advanced to 858 + sequence tr_etoomuch_id_seq advanced to 891 + sequence tr_etoomuch_id_seq advanced to 924 + sequence tr_etoomuch_id_seq advanced to 957 + sequence tr_etoomuch_id_seq advanced to 990 + sequence tr_etoomuch_id_seq advanced to 1023 + sequence tr_etoomuch_id_seq advanced to 1056 + sequence tr_etoomuch_id_seq advanced to 1089 + sequence tr_etoomuch_id_seq advanced to 1122 + sequence tr_etoomuch_id_seq advanced to 1155 + sequence tr_etoomuch_id_seq advanced to 1188 + sequence tr_etoomuch_id_seq advanced to 1221 + sequence tr_etoomuch_id_seq advanced to 1254 + sequence tr_etoomuch_id_seq advanced to 1287 + sequence tr_etoomuch_id_seq advanced to 1320 + sequence tr_etoomuch_id_seq advanced to 1353 + sequence tr_etoomuch_id_seq advanced to 1386 + sequence tr_etoomuch_id_seq advanced to 1419 + sequence tr_etoomuch_id_seq advanced to 1452 + sequence tr_etoomuch_id_seq advanced to 1485 + sequence tr_etoomuch_id_seq advanced to 1518 + sequence tr_etoomuch_id_seq advanced to 1551 + sequence tr_etoomuch_id_seq advanced to 1584 + sequence tr_etoomuch_id_seq advanced to 1617 + sequence tr_etoomuch_id_seq advanced to 1650 + sequence tr_etoomuch_id_seq advanced to 1683 + sequence tr_etoomuch_id_seq advanced to 1716 + sequence tr_etoomuch_id_seq advanced to 1749 + sequence tr_etoomuch_id_seq advanced to 1782 + sequence tr_etoomuch_id_seq advanced to 1815 + sequence tr_etoomuch_id_seq advanced to 1848 + sequence tr_etoomuch_id_seq advanced to 1881 + sequence tr_etoomuch_id_seq advanced to 1914 + sequence tr_etoomuch_id_seq advanced to 1947 + sequence tr_etoomuch_id_seq advanced to 1980 + sequence tr_etoomuch_id_seq advanced to 2013 + sequence tr_etoomuch_id_seq advanced to 2046 + sequence tr_etoomuch_id_seq advanced to 2079 + sequence tr_etoomuch_id_seq advanced to 2112 + sequence tr_etoomuch_id_seq advanced to 2145 + sequence tr_etoomuch_id_seq advanced to 2178 + sequence tr_etoomuch_id_seq advanced to 2211 + sequence tr_etoomuch_id_seq advanced to 2244 + sequence tr_etoomuch_id_seq advanced to 2277 + sequence tr_etoomuch_id_seq advanced to 2310 + sequence tr_etoomuch_id_seq advanced to 2343 + sequence tr_etoomuch_id_seq advanced to 2376 + sequence tr_etoomuch_id_seq advanced to 2409 + sequence tr_etoomuch_id_seq advanced to 2442 + sequence tr_etoomuch_id_seq advanced to 2475 + sequence tr_etoomuch_id_seq advanced to 2508 + sequence tr_etoomuch_id_seq advanced to 2541 + sequence tr_etoomuch_id_seq advanced to 2574 + sequence tr_etoomuch_id_seq advanced to 2607 + sequence tr_etoomuch_id_seq advanced to 2640 + sequence tr_etoomuch_id_seq advanced to 2673 + sequence tr_etoomuch_id_seq advanced to 2706 + sequence tr_etoomuch_id_seq advanced to 2739 + sequence tr_etoomuch_id_seq advanced to 2772 + sequence tr_etoomuch_id_seq advanced to 2805 + sequence tr_etoomuch_id_seq advanced to 2838 + sequence tr_etoomuch_id_seq advanced to 2871 + sequence tr_etoomuch_id_seq advanced to 2904 + sequence tr_etoomuch_id_seq advanced to 2937 + sequence tr_etoomuch_id_seq advanced to 2970 + sequence tr_etoomuch_id_seq advanced to 3003 + sequence tr_etoomuch_id_seq advanced to 3036 + sequence tr_etoomuch_id_seq advanced to 3069 + sequence tr_etoomuch_id_seq advanced to 3102 + sequence tr_etoomuch_id_seq advanced to 3135 + sequence tr_etoomuch_id_seq advanced to 3168 + sequence tr_etoomuch_id_seq advanced to 3201 + sequence tr_etoomuch_id_seq advanced to 3234 + sequence tr_etoomuch_id_seq advanced to 3267 + sequence tr_etoomuch_id_seq advanced to 3300 + sequence tr_etoomuch_id_seq advanced to 3333 + sequence tr_etoomuch_id_seq advanced to 3366 + sequence tr_etoomuch_id_seq advanced to 3399 + sequence tr_etoomuch_id_seq advanced to 3432 + sequence tr_etoomuch_id_seq advanced to 3465 + sequence tr_etoomuch_id_seq advanced to 3498 + sequence tr_etoomuch_id_seq advanced to 3531 + sequence tr_etoomuch_id_seq advanced to 3564 + sequence tr_etoomuch_id_seq advanced to 3597 + sequence tr_etoomuch_id_seq advanced to 3630 + sequence tr_etoomuch_id_seq advanced to 3663 + sequence tr_etoomuch_id_seq advanced to 3696 + sequence tr_etoomuch_id_seq advanced to 3729 + sequence tr_etoomuch_id_seq advanced to 3762 + sequence tr_etoomuch_id_seq advanced to 3795 + sequence tr_etoomuch_id_seq advanced to 3828 + sequence tr_etoomuch_id_seq advanced to 3861 + sequence tr_etoomuch_id_seq advanced to 3894 + sequence tr_etoomuch_id_seq advanced to 3927 + sequence tr_etoomuch_id_seq advanced to 3960 + sequence tr_etoomuch_id_seq advanced to 3993 + sequence tr_etoomuch_id_seq advanced to 4026 + sequence tr_etoomuch_id_seq advanced to 4059 + sequence tr_etoomuch_id_seq advanced to 4092 + sequence tr_etoomuch_id_seq advanced to 4125 + sequence tr_etoomuch_id_seq advanced to 4158 + sequence tr_etoomuch_id_seq advanced to 4191 + sequence tr_etoomuch_id_seq advanced to 4224 + sequence tr_etoomuch_id_seq advanced to 4257 + sequence tr_etoomuch_id_seq advanced to 4290 + sequence tr_etoomuch_id_seq advanced to 4323 + sequence tr_etoomuch_id_seq advanced to 4356 + sequence tr_etoomuch_id_seq advanced to 4389 + sequence tr_etoomuch_id_seq advanced to 4422 + sequence tr_etoomuch_id_seq advanced to 4455 + sequence tr_etoomuch_id_seq advanced to 4488 + sequence tr_etoomuch_id_seq advanced to 4521 + sequence tr_etoomuch_id_seq advanced to 4554 + sequence tr_etoomuch_id_seq advanced to 4587 + sequence tr_etoomuch_id_seq advanced to 4620 + sequence tr_etoomuch_id_seq advanced to 4653 + sequence tr_etoomuch_id_seq advanced to 4686 + sequence tr_etoomuch_id_seq advanced to 4719 + sequence tr_etoomuch_id_seq advanced to 4752 + sequence tr_etoomuch_id_seq advanced to 4785 + sequence tr_etoomuch_id_seq advanced to 4818 + sequence tr_etoomuch_id_seq advanced to 4851 + sequence tr_etoomuch_id_seq advanced to 4884 + sequence tr_etoomuch_id_seq advanced to 4917 + sequence tr_etoomuch_id_seq advanced to 4950 + sequence tr_etoomuch_id_seq advanced to 4983 + sequence tr_etoomuch_id_seq advanced to 5016 + sequence tr_etoomuch_id_seq advanced to 5049 + sequence tr_etoomuch_id_seq advanced to 5082 + sequence tr_etoomuch_id_seq advanced to 5115 + sequence tr_etoomuch_id_seq advanced to 5148 + sequence tr_etoomuch_id_seq advanced to 5181 + sequence tr_etoomuch_id_seq advanced to 5214 + sequence tr_etoomuch_id_seq advanced to 5247 + sequence tr_etoomuch_id_seq advanced to 5280 + sequence tr_etoomuch_id_seq advanced to 5313 + sequence tr_etoomuch_id_seq advanced to 5346 + sequence tr_etoomuch_id_seq advanced to 5379 + sequence tr_etoomuch_id_seq advanced to 5412 + sequence tr_etoomuch_id_seq advanced to 5445 + sequence tr_etoomuch_id_seq advanced to 5478 + sequence tr_etoomuch_id_seq advanced to 5511 + sequence tr_etoomuch_id_seq advanced to 5544 + sequence tr_etoomuch_id_seq advanced to 5577 + sequence tr_etoomuch_id_seq advanced to 5610 + sequence tr_etoomuch_id_seq advanced to 5643 + sequence tr_etoomuch_id_seq advanced to 5676 + sequence tr_etoomuch_id_seq advanced to 5709 + sequence tr_etoomuch_id_seq advanced to 5742 + sequence tr_etoomuch_id_seq advanced to 5775 + sequence tr_etoomuch_id_seq advanced to 5808 + sequence tr_etoomuch_id_seq advanced to 5841 + sequence tr_etoomuch_id_seq advanced to 5874 + sequence tr_etoomuch_id_seq advanced to 5907 + sequence tr_etoomuch_id_seq advanced to 5940 + sequence tr_etoomuch_id_seq advanced to 5973 + sequence tr_etoomuch_id_seq advanced to 6006 + sequence tr_etoomuch_id_seq advanced to 6039 + sequence tr_etoomuch_id_seq advanced to 6072 + sequence tr_etoomuch_id_seq advanced to 6105 + sequence tr_etoomuch_id_seq advanced to 6138 + sequence tr_etoomuch_id_seq advanced to 6171 + sequence tr_etoomuch_id_seq advanced to 6204 + sequence tr_etoomuch_id_seq advanced to 6237 + sequence tr_etoomuch_id_seq advanced to 6270 + sequence tr_etoomuch_id_seq advanced to 6303 + sequence tr_etoomuch_id_seq advanced to 6336 + sequence tr_etoomuch_id_seq advanced to 6369 + sequence tr_etoomuch_id_seq advanced to 6402 + sequence tr_etoomuch_id_seq advanced to 6435 + sequence tr_etoomuch_id_seq advanced to 6468 + sequence tr_etoomuch_id_seq advanced to 6501 + sequence tr_etoomuch_id_seq advanced to 6534 + sequence tr_etoomuch_id_seq advanced to 6567 + sequence tr_etoomuch_id_seq advanced to 6600 + sequence tr_etoomuch_id_seq advanced to 6633 + sequence tr_etoomuch_id_seq advanced to 6666 + sequence tr_etoomuch_id_seq advanced to 6699 + sequence tr_etoomuch_id_seq advanced to 6732 + sequence tr_etoomuch_id_seq advanced to 6765 + sequence tr_etoomuch_id_seq advanced to 6798 + sequence tr_etoomuch_id_seq advanced to 6831 + sequence tr_etoomuch_id_seq advanced to 6864 + sequence tr_etoomuch_id_seq advanced to 6897 + sequence tr_etoomuch_id_seq advanced to 6930 + sequence tr_etoomuch_id_seq advanced to 6963 + sequence tr_etoomuch_id_seq advanced to 6996 + sequence tr_etoomuch_id_seq advanced to 7029 + sequence tr_etoomuch_id_seq advanced to 7062 + sequence tr_etoomuch_id_seq advanced to 7095 + sequence tr_etoomuch_id_seq advanced to 7128 + sequence tr_etoomuch_id_seq advanced to 7161 + sequence tr_etoomuch_id_seq advanced to 7194 + sequence tr_etoomuch_id_seq advanced to 7227 + sequence tr_etoomuch_id_seq advanced to 7260 + sequence tr_etoomuch_id_seq advanced to 7293 + sequence tr_etoomuch_id_seq advanced to 7326 + sequence tr_etoomuch_id_seq advanced to 7359 + sequence tr_etoomuch_id_seq advanced to 7392 + sequence tr_etoomuch_id_seq advanced to 7425 + sequence tr_etoomuch_id_seq advanced to 7458 + sequence tr_etoomuch_id_seq advanced to 7491 + sequence tr_etoomuch_id_seq advanced to 7524 + sequence tr_etoomuch_id_seq advanced to 7557 + sequence tr_etoomuch_id_seq advanced to 7590 + sequence tr_etoomuch_id_seq advanced to 7623 + sequence tr_etoomuch_id_seq advanced to 7656 + sequence tr_etoomuch_id_seq advanced to 7689 + sequence tr_etoomuch_id_seq advanced to 7722 + sequence tr_etoomuch_id_seq advanced to 7755 + sequence tr_etoomuch_id_seq advanced to 7788 + sequence tr_etoomuch_id_seq advanced to 7821 + sequence tr_etoomuch_id_seq advanced to 7854 + sequence tr_etoomuch_id_seq advanced to 7887 + sequence tr_etoomuch_id_seq advanced to 7920 + sequence tr_etoomuch_id_seq advanced to 7953 + sequence tr_etoomuch_id_seq advanced to 7986 + sequence tr_etoomuch_id_seq advanced to 8019 + sequence tr_etoomuch_id_seq advanced to 8052 + sequence tr_etoomuch_id_seq advanced to 8085 + sequence tr_etoomuch_id_seq advanced to 8118 + sequence tr_etoomuch_id_seq advanced to 8151 + sequence tr_etoomuch_id_seq advanced to 8184 + sequence tr_etoomuch_id_seq advanced to 8217 + sequence tr_etoomuch_id_seq advanced to 8250 + sequence tr_etoomuch_id_seq advanced to 8283 + sequence tr_etoomuch_id_seq advanced to 8316 + sequence tr_etoomuch_id_seq advanced to 8349 + sequence tr_etoomuch_id_seq advanced to 8382 + sequence tr_etoomuch_id_seq advanced to 8415 + sequence tr_etoomuch_id_seq advanced to 8448 + sequence tr_etoomuch_id_seq advanced to 8481 + sequence tr_etoomuch_id_seq advanced to 8514 + sequence tr_etoomuch_id_seq advanced to 8547 + sequence tr_etoomuch_id_seq advanced to 8580 + sequence tr_etoomuch_id_seq advanced to 8613 + sequence tr_etoomuch_id_seq advanced to 8646 + sequence tr_etoomuch_id_seq advanced to 8679 + sequence tr_etoomuch_id_seq advanced to 8712 + sequence tr_etoomuch_id_seq advanced to 8745 + sequence tr_etoomuch_id_seq advanced to 8778 + sequence tr_etoomuch_id_seq advanced to 8811 + sequence tr_etoomuch_id_seq advanced to 8844 + sequence tr_etoomuch_id_seq advanced to 8877 + sequence tr_etoomuch_id_seq advanced to 8910 + sequence tr_etoomuch_id_seq advanced to 8943 + sequence tr_etoomuch_id_seq advanced to 8976 + sequence tr_etoomuch_id_seq advanced to 9009 + sequence tr_etoomuch_id_seq advanced to 9042 + sequence tr_etoomuch_id_seq advanced to 9075 + sequence tr_etoomuch_id_seq advanced to 9108 + sequence tr_etoomuch_id_seq advanced to 9141 + sequence tr_etoomuch_id_seq advanced to 9174 + sequence tr_etoomuch_id_seq advanced to 9207 + sequence tr_etoomuch_id_seq advanced to 9240 + sequence tr_etoomuch_id_seq advanced to 9273 + sequence tr_etoomuch_id_seq advanced to 9306 + sequence tr_etoomuch_id_seq advanced to 9339 + sequence tr_etoomuch_id_seq advanced to 9372 + sequence tr_etoomuch_id_seq advanced to 9405 + sequence tr_etoomuch_id_seq advanced to 9438 + sequence tr_etoomuch_id_seq advanced to 9471 + sequence tr_etoomuch_id_seq advanced to 9504 + sequence tr_etoomuch_id_seq advanced to 9537 + sequence tr_etoomuch_id_seq advanced to 9570 + sequence tr_etoomuch_id_seq advanced to 9603 + sequence tr_etoomuch_id_seq advanced to 9636 + sequence tr_etoomuch_id_seq advanced to 9669 + sequence tr_etoomuch_id_seq advanced to 9702 + sequence tr_etoomuch_id_seq advanced to 9735 + sequence tr_etoomuch_id_seq advanced to 9768 + sequence tr_etoomuch_id_seq advanced to 9801 + sequence tr_etoomuch_id_seq advanced to 9834 + sequence tr_etoomuch_id_seq advanced to 9867 + sequence tr_etoomuch_id_seq advanced to 9900 + sequence tr_etoomuch_id_seq advanced to 9933 + sequence tr_etoomuch_id_seq advanced to 9966 + sequence tr_etoomuch_id_seq advanced to 9999 + sequence tr_etoomuch_id_seq advanced to 10032 + sequence tr_etoomuch_id_seq advanced to 10065 + sequence tr_etoomuch_id_seq advanced to 10098 + sequence tr_etoomuch_id_seq advanced to 10131 + sequence tr_etoomuch_id_seq advanced to 10164 + sequence tr_etoomuch_id_seq advanced to 10197 + sequence tr_etoomuch_id_seq advanced to 10230 + sequence tr_etoomuch_id_seq advanced to 10263 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 1 + sequence tr_sub_id_seq advanced to 33 + sequence replication_metadata_id_seq advanced to 1 + sequence replication_metadata_id_seq advanced to 1 + sequence replication_metadata_id_seq advanced to 33 + sequence table_without_key_id_seq advanced to 1 + sequence table_without_key_id_seq advanced to 1 + sequence table_without_key_id_seq advanced to 33 + sequence table_with_pkey_id_seq advanced to 1 + sequence table_with_pkey_id_seq advanced to 1 + sequence table_with_pkey_id_seq advanced to 33 + sequence table_with_unique_not_null_id_seq advanced to 1 + sequence table_with_unique_not_null_id_seq advanced to 1 + sequence table_with_unique_not_null_id_seq advanced to 33 + sequence toasttable_rand_seq advanced to 79 + sequence toasttable_id_seq advanced to 1 + sequence toasttable_id_seq advanced to 1 + sequence toasttable_id_seq advanced to 33 + sequence toasttable_rand_seq advanced to 48047 +(342 rows) SELECT pg_drop_replication_slot('regression_slot'); pg_drop_replication_slot diff --git a/contrib/test_decoding/expected/decoding_in_xact.out b/contrib/test_decoding/expected/decoding_in_xact.out index ab4d3ae..e67feaa 100644 --- a/contrib/test_decoding/expected/decoding_in_xact.out +++ b/contrib/test_decoding/expected/decoding_in_xact.out @@ -61,23 +61,29 @@ INSERT INTO nobarf(data) VALUES('2'); SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ----------------------------------------------------------- + sequence nobarf_id_seq advanced to 1 + sequence nobarf_id_seq advanced to 1 + sequence nobarf_id_seq advanced to 33 BEGIN table public.nobarf: INSERT: id[integer]:1 data[text]:'1' COMMIT -(3 rows) +(6 rows) COMMIT; INSERT INTO nobarf(data) VALUES('3'); SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ----------------------------------------------------------- + sequence nobarf_id_seq advanced to 1 + sequence nobarf_id_seq advanced to 1 + sequence nobarf_id_seq advanced to 33 BEGIN table public.nobarf: INSERT: id[integer]:2 data[text]:'2' COMMIT BEGIN table public.nobarf: INSERT: id[integer]:3 data[text]:'3' COMMIT -(6 rows) +(9 rows) SELECT 'stop' FROM pg_drop_replication_slot('regression_slot'); ?column? diff --git a/contrib/test_decoding/expected/decoding_into_rel.out b/contrib/test_decoding/expected/decoding_into_rel.out index be759ca..dc1da02 100644 --- a/contrib/test_decoding/expected/decoding_into_rel.out +++ b/contrib/test_decoding/expected/decoding_into_rel.out @@ -23,10 +23,13 @@ CREATE TABLE changeresult AS SELECT * FROM changeresult; data ------------------------------------------------ + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 33 BEGIN table public.somechange: INSERT: id[integer]:1 COMMIT -(3 rows) +(6 rows) INSERT INTO changeresult SELECT data FROM pg_logical_slot_peek_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); @@ -35,48 +38,84 @@ INSERT INTO changeresult SELECT * FROM changeresult; data -------------------------------------------------------------------------------------------------------------------------------------------------- + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 33 BEGIN table public.somechange: INSERT: id[integer]:1 COMMIT + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 33 BEGIN + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 1' + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 1' + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 33' table public.changeresult: INSERT: data[text]:'BEGIN' table public.changeresult: INSERT: data[text]:'table public.somechange: INSERT: id[integer]:1' table public.changeresult: INSERT: data[text]:'COMMIT' COMMIT + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 33 BEGIN + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 1' + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 1' + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 33' table public.changeresult: INSERT: data[text]:'BEGIN' table public.changeresult: INSERT: data[text]:'table public.somechange: INSERT: id[integer]:1' table public.changeresult: INSERT: data[text]:'COMMIT' COMMIT BEGIN + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 1' + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 1' + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 33' table public.changeresult: INSERT: data[text]:'BEGIN' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 1''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 1''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 33''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''BEGIN''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''table public.somechange: INSERT: id[integer]:1''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''COMMIT''' table public.changeresult: INSERT: data[text]:'COMMIT' COMMIT -(20 rows) +(41 rows) DROP TABLE changeresult; DROP TABLE somechange; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 1 + sequence somechange_id_seq advanced to 33 BEGIN + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 1' + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 1' + table public.changeresult: INSERT: data[text]:'sequence somechange_id_seq advanced to 33' table public.changeresult: INSERT: data[text]:'BEGIN' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 1''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 1''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 33''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''BEGIN''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''table public.somechange: INSERT: id[integer]:1''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''COMMIT''' table public.changeresult: INSERT: data[text]:'COMMIT' table public.changeresult: INSERT: data[text]:'BEGIN' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 1''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 1''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''sequence somechange_id_seq advanced to 33''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''BEGIN''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''table public.changeresult: INSERT: data[text]:''''sequence somechange_id_seq advanced to 1''''''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''table public.changeresult: INSERT: data[text]:''''sequence somechange_id_seq advanced to 1''''''' + table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''table public.changeresult: INSERT: data[text]:''''sequence somechange_id_seq advanced to 33''''''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''table public.changeresult: INSERT: data[text]:''''BEGIN''''''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''table public.changeresult: INSERT: data[text]:''''table public.somechange: INSERT: id[integer]:1''''''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''table public.changeresult: INSERT: data[text]:''''COMMIT''''''' table public.changeresult: INSERT: data[text]:'table public.changeresult: INSERT: data[text]:''COMMIT''' table public.changeresult: INSERT: data[text]:'COMMIT' COMMIT -(14 rows) +(29 rows) SELECT 'stop' FROM pg_drop_replication_slot('regression_slot'); ?column? diff --git a/contrib/test_decoding/expected/mxact.out b/contrib/test_decoding/expected/mxact.out index f0d96cc..cea866c 100644 --- a/contrib/test_decoding/expected/mxact.out +++ b/contrib/test_decoding/expected/mxact.out @@ -22,6 +22,7 @@ step s0w: INSERT INTO do_write DEFAULT VALUES; step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); data +sequence do_write_id_seq advanced to 33 BEGIN table public.do_write: INSERT: id[integer]:1 COMMIT @@ -56,6 +57,7 @@ data BEGIN COMMIT +sequence do_write_id_seq advanced to 33 BEGIN table public.do_write: INSERT: id[integer]:1 ts[timestamp with time zone]:null COMMIT diff --git a/contrib/test_decoding/expected/ondisk_startup.out b/contrib/test_decoding/expected/ondisk_startup.out index 65115c8..5b798d5 100644 --- a/contrib/test_decoding/expected/ondisk_startup.out +++ b/contrib/test_decoding/expected/ondisk_startup.out @@ -21,6 +21,7 @@ step s1checkpoint: CHECKPOINT; step s1start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); data +sequence do_write_id_seq advanced to 33 BEGIN table public.do_write: INSERT: id[integer]:1 addedbys2[integer]:null COMMIT @@ -30,6 +31,7 @@ step s1insert: INSERT INTO do_write DEFAULT VALUES; step s1start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false'); data +sequence do_write_id_seq advanced to 34 BEGIN table public.do_write: INSERT: id[integer]:2 addedbys2[integer]:null COMMIT diff --git a/contrib/test_decoding/expected/replorigin.out b/contrib/test_decoding/expected/replorigin.out index c0f5125..83a524a 100644 --- a/contrib/test_decoding/expected/replorigin.out +++ b/contrib/test_decoding/expected/replorigin.out @@ -41,12 +41,15 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + sequence origin_tbl_id_seq advanced to 33 + sequence target_tbl_id_seq advanced to 33 BEGIN - table public.target_tbl: INSERT: id[integer]:1 data[text]:'BEGIN' - table public.target_tbl: INSERT: id[integer]:2 data[text]:'table public.origin_tbl: INSERT: id[integer]:1 data[text]:''will be replicated and decoded and decoded again''' - table public.target_tbl: INSERT: id[integer]:3 data[text]:'COMMIT' + table public.target_tbl: INSERT: id[integer]:1 data[text]:'sequence origin_tbl_id_seq advanced to 33' + table public.target_tbl: INSERT: id[integer]:2 data[text]:'BEGIN' + table public.target_tbl: INSERT: id[integer]:3 data[text]:'table public.origin_tbl: INSERT: id[integer]:1 data[text]:''will be replicated and decoded and decoded again''' + table public.target_tbl: INSERT: id[integer]:4 data[text]:'COMMIT' COMMIT -(5 rows) +(8 rows) INSERT INTO origin_tbl(data) VALUES ('will be replicated, but not decoded again'); -- mark session as replaying @@ -113,19 +116,23 @@ SELECT pg_replication_origin_session_reset(); ERROR: no replication origin is configured -- and magically the replayed xact will be filtered! SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'only-local', '1'); - data ------- -(0 rows) + data +------------------------------------------- + sequence origin_tbl_id_seq advanced to 33 + sequence target_tbl_id_seq advanced to 33 +(2 rows) --but new original changes still show up INSERT INTO origin_tbl(data) VALUES ('will be replicated'); SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1', 'only-local', '1'); data -------------------------------------------------------------------------------- + sequence origin_tbl_id_seq advanced to 33 + sequence target_tbl_id_seq advanced to 33 BEGIN table public.origin_tbl: INSERT: id[integer]:3 data[text]:'will be replicated' COMMIT -(3 rows) +(5 rows) SELECT pg_drop_replication_slot('regression_slot'); pg_drop_replication_slot diff --git a/contrib/test_decoding/expected/rewrite.out b/contrib/test_decoding/expected/rewrite.out index 4dcd489..93ed617 100644 --- a/contrib/test_decoding/expected/rewrite.out +++ b/contrib/test_decoding/expected/rewrite.out @@ -12,10 +12,13 @@ INSERT INTO replication_example(somedata) VALUES (1); SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ---------------------------------------------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 BEGIN table public.replication_example: INSERT: id[integer]:1 somedata[integer]:1 text[character varying]:null COMMIT -(3 rows) +(6 rows) BEGIN; INSERT INTO replication_example(somedata) VALUES (2); @@ -59,6 +62,9 @@ CHECKPOINT; SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); data ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 1 + sequence replication_example_id_seq advanced to 33 BEGIN table public.replication_example: INSERT: id[integer]:2 somedata[integer]:2 text[character varying]:null table public.replication_example: INSERT: id[integer]:3 somedata[integer]:3 text[character varying]:null testcolumn1[integer]:1 @@ -74,7 +80,7 @@ SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'inc table public.replication_example: INSERT: id[integer]:7 somedata[integer]:6 text[character varying]:null testcolumn1[integer]:4 testcolumn2[integer]:null table public.replication_example: INSERT: id[integer]:8 somedata[integer]:7 text[character varying]:null testcolumn1[integer]:5 testcolumn2[integer]:null testcolumn3[integer]:1 COMMIT -(15 rows) +(18 rows) SELECT pg_drop_replication_slot('regression_slot'); pg_drop_replication_slot diff --git a/contrib/test_decoding/expected/toast.out b/contrib/test_decoding/expected/toast.out index 735b14c..0d3d1cd 100644 --- a/contrib/test_decoding/expected/toast.out +++ b/contrib/test_decoding/expected/toast.out @@ -55,6 +55,11 @@ ALTER TABLE toasted_copy ALTER COLUMN data SET STORAGE EXTERNAL; SELECT substr(data, 1, 200) FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1'); substr ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + sequence xpto_rand_seq advanced to 79 + sequence xpto_id_seq advanced to 1 + sequence xpto_id_seq advanced to 1 + sequence xpto_id_seq advanced to 33 + sequence xpto_rand_seq advanced to 48047 BEGIN table public.xpto: INSERT: id[integer]:1 toasted_col1[text]:'1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374 COMMIT @@ -73,6 +78,9 @@ SELECT substr(data, 1, 200) FROM pg_logical_slot_get_changes('regression_slot', BEGIN table public.xpto: DELETE: id[integer]:1 COMMIT + sequence toasted_key_id_seq advanced to 1 + sequence toasted_key_id_seq advanced to 1 + sequence toasted_key_id_seq advanced to 33 BEGIN table public.toasted_key: INSERT: id[integer]:1 toasted_key[text]:'1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123 COMMIT @@ -290,7 +298,7 @@ SELECT substr(data, 1, 200) FROM pg_logical_slot_get_changes('regression_slot', table public.toasted_copy: INSERT: id[integer]:202 data[text]:'untoasted199' table public.toasted_copy: INSERT: id[integer]:203 data[text]:'untoasted200' COMMIT -(235 rows) +(243 rows) SELECT pg_drop_replication_slot('regression_slot'); pg_drop_replication_slot diff --git a/contrib/test_decoding/test_decoding.c b/contrib/test_decoding/test_decoding.c index 80fc5f4..c1456ca 100644 --- a/contrib/test_decoding/test_decoding.c +++ b/contrib/test_decoding/test_decoding.c @@ -64,6 +64,9 @@ static void pg_decode_change(LogicalDecodingContext *ctx, static bool pg_decode_filter(LogicalDecodingContext *ctx, RepOriginId origin_id); +static void pg_decode_seq_advance(LogicalDecodingContext *ctx, + const char * seq_name, uint64 last_value); + void _PG_init(void) { @@ -82,6 +85,7 @@ _PG_output_plugin_init(OutputPluginCallbacks *cb) cb->commit_cb = pg_decode_commit_txn; cb->filter_by_origin_cb = pg_decode_filter; cb->shutdown_cb = pg_decode_shutdown; + cb->seq_advance_cb = pg_decode_seq_advance; } @@ -251,6 +255,18 @@ pg_decode_filter(LogicalDecodingContext *ctx, return false; } +static void +pg_decode_seq_advance(LogicalDecodingContext *ctx, const char * seq_name, + uint64 last_value) +{ + OutputPluginPrepareWrite(ctx, true); + + appendStringInfo(ctx->out, "sequence %s advanced to "UINT64_FORMAT, + seq_name, last_value); + + OutputPluginWrite(ctx, true); +} + /* * Print literal `outputstr' already represented as string of type `typid' * into stringbuf `s'. diff --git a/src/backend/replication/logical/decode.c b/src/backend/replication/logical/decode.c index 9f60687..c32f509 100644 --- a/src/backend/replication/logical/decode.c +++ b/src/backend/replication/logical/decode.c @@ -37,6 +37,8 @@ #include "catalog/pg_control.h" +#include "commands/sequence.h" + #include "replication/decode.h" #include "replication/logical.h" #include "replication/reorderbuffer.h" @@ -58,6 +60,7 @@ static void DecodeHeapOp(LogicalDecodingContext *ctx, XLogRecordBuffer *buf); static void DecodeHeap2Op(LogicalDecodingContext *ctx, XLogRecordBuffer *buf); static void DecodeXactOp(LogicalDecodingContext *ctx, XLogRecordBuffer *buf); static void DecodeStandbyOp(LogicalDecodingContext *ctx, XLogRecordBuffer *buf); +static void DecodeSeqOp(LogicalDecodingContext *ctx, XLogRecordBuffer *buf); /* individual record(group)'s handlers */ static void DecodeInsert(LogicalDecodingContext *ctx, XLogRecordBuffer *buf); @@ -71,6 +74,9 @@ static void DecodeCommit(LogicalDecodingContext *ctx, XLogRecordBuffer *buf, static void DecodeAbort(LogicalDecodingContext *ctx, XLogRecordBuffer *buf, xl_xact_parsed_abort *parsed, TransactionId xid); +static void DecodeSeqAdvance(LogicalDecodingContext *ctx, XLogRecordBuffer *buf, + Form_pg_sequence seq); + /* common function to decode tuples */ static void DecodeXLogTuple(char *data, Size len, ReorderBufferTupleBuf *tup); @@ -107,6 +113,10 @@ LogicalDecodingProcessRecord(LogicalDecodingContext *ctx, XLogReaderState *recor DecodeStandbyOp(ctx, &buf); break; + case RM_SEQ_ID: + DecodeSeqOp(ctx, &buf); + break; + case RM_HEAP2_ID: DecodeHeap2Op(ctx, &buf); break; @@ -130,7 +140,6 @@ LogicalDecodingProcessRecord(LogicalDecodingContext *ctx, XLogReaderState *recor case RM_HASH_ID: case RM_GIN_ID: case RM_GIST_ID: - case RM_SEQ_ID: case RM_SPGIST_ID: case RM_BRIN_ID: case RM_COMMIT_TS_ID: @@ -303,6 +312,30 @@ DecodeStandbyOp(LogicalDecodingContext *ctx, XLogRecordBuffer *buf) } } +static void +DecodeSeqOp(LogicalDecodingContext *ctx, XLogRecordBuffer *buf) +{ + SnapBuild *builder = ctx->snapshot_builder; + uint8 info = XLogRecGetInfo(buf->record) & ~XLR_INFO_MASK; + xl_seq_rec *xlrec = (xl_seq_rec *) XLogRecGetData(buf->record); + HeapTuple item; + Form_pg_sequence seq; + + /* no point in doing anything yet */ + if (SnapBuildCurrentState(builder) < SNAPBUILD_FULL_SNAPSHOT) + return; + + if (info != XLOG_SEQ_LOG) + elog(PANIC, "DecodeSeqOp: unknown sequence xlog op code %u", info); + + /* nextval_internal etc write a xl_seq_rec immediately followed by a HeapTupleData */ + item = (HeapTuple)((char*)xlrec + sizeof(xl_seq_rec)); + + seq = (Form_pg_sequence)((char*)item + HEAPTUPLESIZE); + + DecodeSeqAdvance(ctx, buf, seq); +} + /* * Handle rmgr HEAP2_ID records for DecodeRecordIntoReorderBuffer(). */ @@ -838,6 +871,31 @@ DecodeSpecConfirm(LogicalDecodingContext *ctx, XLogRecordBuffer *buf) ReorderBufferQueueChange(ctx->reorder, XLogRecGetXid(r), buf->origptr, change); } +static void +DecodeSeqAdvance(LogicalDecodingContext *ctx, XLogRecordBuffer *buf, + Form_pg_sequence seq) +{ + XLogReaderState *r = buf->record; + RelFileNode target_node; + + /* If the output plugin isn't interested, don't waste any time */ + if (ctx->callbacks.seq_advance_cb == NULL) + return; + + /* only interested in our database */ + XLogRecGetBlockTag(r, 0, &target_node, NULL, NULL); + if (target_node.dbNode != ctx->slot->data.database) + return; + + /* + * Because sequences are updated outside transaction boundaries there + * is no need to use a reorder buffer here. We invoke the logical + * decoding plugin callback immediately. + */ + seq_advance_cb_wrapper(ctx, buf->origptr, NameStr(seq->sequence_name), + seq->last_value); +} + /* * Read a HeapTuple as WAL logged by heap_insert, heap_update and heap_delete diff --git a/src/backend/replication/logical/logical.c b/src/backend/replication/logical/logical.c index 1ce9081..30527df 100644 --- a/src/backend/replication/logical/logical.c +++ b/src/backend/replication/logical/logical.c @@ -683,7 +683,7 @@ filter_by_origin_cb_wrapper(LogicalDecodingContext *ctx, RepOriginId origin_id) /* Push callback + info on the error context stack */ state.ctx = ctx; - state.callback_name = "shutdown"; + state.callback_name = "filter_by_origin"; state.report_location = InvalidXLogRecPtr; errcallback.callback = output_plugin_error_callback; errcallback.arg = (void *) &state; @@ -702,6 +702,32 @@ filter_by_origin_cb_wrapper(LogicalDecodingContext *ctx, RepOriginId origin_id) return ret; } +void +seq_advance_cb_wrapper(LogicalDecodingContext *ctx, XLogRecPtr change_lsn, + const char * seq_name, uint64 last_value) +{ + LogicalErrorCallbackState state; + ErrorContextCallback errcallback; + + /* Push callback + info on the error context stack */ + state.ctx = ctx; + state.callback_name = "advance_seq"; + state.report_location = change_lsn; + errcallback.callback = output_plugin_error_callback; + errcallback.arg = (void *) &state; + errcallback.previous = error_context_stack; + error_context_stack = &errcallback; + + ctx->accept_writes = true; + + /* do the actual work: call callback */ + ctx->callbacks.seq_advance_cb(ctx, seq_name, last_value); + + /* Pop the error context stack */ + error_context_stack = errcallback.previous; +} + + /* * Set the required catalog xmin horizon for historic snapshots in the current * replication slot. diff --git a/src/include/replication/logical.h b/src/include/replication/logical.h index dfdbe65..ba9f936 100644 --- a/src/include/replication/logical.h +++ b/src/include/replication/logical.h @@ -99,4 +99,7 @@ extern void LogicalConfirmReceivedLocation(XLogRecPtr lsn); extern bool filter_by_origin_cb_wrapper(LogicalDecodingContext *ctx, RepOriginId origin_id); +extern void seq_advance_cb_wrapper(LogicalDecodingContext *ctx, + XLogRecPtr change_lsn, const char * seq_name, uint64 last_value); + #endif diff --git a/src/include/replication/output_plugin.h b/src/include/replication/output_plugin.h index 17c3de2..f6d6a10 100644 --- a/src/include/replication/output_plugin.h +++ b/src/include/replication/output_plugin.h @@ -88,6 +88,21 @@ typedef void (*LogicalDecodeShutdownCB) ( ); /* + * A sequence has been advanced, with a new chunk allocated and written + * to WAL. + * + * This doesn't happen every time nextval() is called, there's caching. It's + * guaranteed that the new sequence position will be at or ahead of the most + * recent value any committed xact has obtained when this callback is invoked. + */ +typedef void (*LogicalDecodeSeqAdvanceCB) ( + struct LogicalDecodingContext *, + const char * seq_name, + uint64 last_value + ); + + +/* * Output plugin callbacks */ typedef struct OutputPluginCallbacks @@ -98,6 +113,7 @@ typedef struct OutputPluginCallbacks LogicalDecodeCommitCB commit_cb; LogicalDecodeFilterByOriginCB filter_by_origin_cb; LogicalDecodeShutdownCB shutdown_cb; + LogicalDecodeSeqAdvanceCB seq_advance_cb; } OutputPluginCallbacks; void OutputPluginPrepareWrite(struct LogicalDecodingContext *ctx, bool last_write); -- 2.1.0