@@ -697,12 +697,12 @@ UPDATE testpub_tbl6 SET a = 1;
697
697
CREATE TABLE testpub_tbl7 (a int primary key, b text, c text);
698
698
ALTER PUBLICATION testpub_fortable ADD TABLE testpub_tbl7 (a, b);
699
699
\d+ testpub_tbl7
700
- Table "public.testpub_tbl7"
701
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
702
- --------+---------+-----------+----------+---------+----------+--------------+-------------
703
- a | integer | | not null | | plain | |
704
- b | text | | | | extended | |
705
- c | text | | | | extended | |
700
+ Table "public.testpub_tbl7"
701
+ Column | Type | Collation | Nullable | Default | Storage | Toaster | Stats target | Description
702
+ --------+---------+-----------+----------+---------+----------+------------+------------ --+-------------
703
+ a | integer | | not null | | plain | | |
704
+ b | text | | | | extended | deftoaster | |
705
+ c | text | | | | extended | deftoaster | |
706
706
Indexes:
707
707
"testpub_tbl7_pkey" PRIMARY KEY, btree (a)
708
708
Publications:
@@ -711,12 +711,12 @@ Publications:
711
711
-- ok: the column list is the same, we should skip this table (or at least not fail)
712
712
ALTER PUBLICATION testpub_fortable SET TABLE testpub_tbl7 (a, b);
713
713
\d+ testpub_tbl7
714
- Table "public.testpub_tbl7"
715
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
716
- --------+---------+-----------+----------+---------+----------+--------------+-------------
717
- a | integer | | not null | | plain | |
718
- b | text | | | | extended | |
719
- c | text | | | | extended | |
714
+ Table "public.testpub_tbl7"
715
+ Column | Type | Collation | Nullable | Default | Storage | Toaster | Stats target | Description
716
+ --------+---------+-----------+----------+---------+----------+------------+------------ --+-------------
717
+ a | integer | | not null | | plain | | |
718
+ b | text | | | | extended | deftoaster | |
719
+ c | text | | | | extended | deftoaster | |
720
720
Indexes:
721
721
"testpub_tbl7_pkey" PRIMARY KEY, btree (a)
722
722
Publications:
@@ -725,12 +725,12 @@ Publications:
725
725
-- ok: the column list changes, make sure the catalog gets updated
726
726
ALTER PUBLICATION testpub_fortable SET TABLE testpub_tbl7 (a, c);
727
727
\d+ testpub_tbl7
728
- Table "public.testpub_tbl7"
729
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
730
- --------+---------+-----------+----------+---------+----------+--------------+-------------
731
- a | integer | | not null | | plain | |
732
- b | text | | | | extended | |
733
- c | text | | | | extended | |
728
+ Table "public.testpub_tbl7"
729
+ Column | Type | Collation | Nullable | Default | Storage | Toaster | Stats target | Description
730
+ --------+---------+-----------+----------+---------+----------+------------+------------ --+-------------
731
+ a | integer | | not null | | plain | | |
732
+ b | text | | | | extended | deftoaster | |
733
+ c | text | | | | extended | deftoaster | |
734
734
Indexes:
735
735
"testpub_tbl7_pkey" PRIMARY KEY, btree (a)
736
736
Publications:
@@ -829,12 +829,12 @@ Tables:
829
829
"public.testpub_tbl_both_filters" (a, c) WHERE (c <> 1)
830
830
831
831
\d+ testpub_tbl_both_filters
832
- Table "public.testpub_tbl_both_filters"
833
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
834
- --------+---------+-----------+----------+---------+---------+--------------+-------------
835
- a | integer | | not null | | plain | |
836
- b | integer | | | | plain | |
837
- c | integer | | not null | | plain | |
832
+ Table "public.testpub_tbl_both_filters"
833
+ Column | Type | Collation | Nullable | Default | Storage | Toaster | Stats target | Description
834
+ --------+---------+-----------+----------+---------+---------+---------+--------- -----+-------------
835
+ a | integer | | not null | | plain | | |
836
+ b | integer | | | | plain | | |
837
+ c | integer | | not null | | plain | | |
838
838
Indexes:
839
839
"testpub_tbl_both_filters_pkey" PRIMARY KEY, btree (a, c) REPLICA IDENTITY
840
840
Publications:
0 commit comments