@@ -438,12 +438,12 @@ CREATE TABLE replication_metadata (
438
438
WITH (user_catalog_table = true)
439
439
;
440
440
\d+ replication_metadata
441
- Table "public.replication_metadata"
442
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
443
- ----------+---------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
444
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | |
445
- relation | name | | not null | | plain | |
446
- options | text[] | | | | extended | |
441
+ Table "public.replication_metadata"
442
+ Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
443
+ ----------+---------+-----------+----------+--------------------------------------------------+----------+-------------+------------- -+-------------
444
+ id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | | |
445
+ relation | name | | not null | | plain | | |
446
+ options | text[] | | | | extended | pglz | |
447
447
Indexes:
448
448
"replication_metadata_pkey" PRIMARY KEY, btree (id)
449
449
Options: user_catalog_table=true
@@ -452,25 +452,25 @@ INSERT INTO replication_metadata(relation, options)
452
452
VALUES ('foo', ARRAY['a', 'b']);
453
453
ALTER TABLE replication_metadata RESET (user_catalog_table);
454
454
\d+ replication_metadata
455
- Table "public.replication_metadata"
456
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
457
- ----------+---------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
458
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | |
459
- relation | name | | not null | | plain | |
460
- options | text[] | | | | extended | |
455
+ Table "public.replication_metadata"
456
+ Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
457
+ ----------+---------+-----------+----------+--------------------------------------------------+----------+-------------+------------- -+-------------
458
+ id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | | |
459
+ relation | name | | not null | | plain | | |
460
+ options | text[] | | | | extended | pglz | |
461
461
Indexes:
462
462
"replication_metadata_pkey" PRIMARY KEY, btree (id)
463
463
464
464
INSERT INTO replication_metadata(relation, options)
465
465
VALUES ('bar', ARRAY['a', 'b']);
466
466
ALTER TABLE replication_metadata SET (user_catalog_table = true);
467
467
\d+ replication_metadata
468
- Table "public.replication_metadata"
469
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
470
- ----------+---------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
471
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | |
472
- relation | name | | not null | | plain | |
473
- options | text[] | | | | extended | |
468
+ Table "public.replication_metadata"
469
+ Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
470
+ ----------+---------+-----------+----------+--------------------------------------------------+----------+-------------+------------- -+-------------
471
+ id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | | |
472
+ relation | name | | not null | | plain | | |
473
+ options | text[] | | | | extended | pglz | |
474
474
Indexes:
475
475
"replication_metadata_pkey" PRIMARY KEY, btree (id)
476
476
Options: user_catalog_table=true
@@ -483,13 +483,13 @@ ALTER TABLE replication_metadata ALTER COLUMN rewritemeornot TYPE text;
483
483
ERROR: cannot rewrite table "replication_metadata" used as a catalog table
484
484
ALTER TABLE replication_metadata SET (user_catalog_table = false);
485
485
\d+ replication_metadata
486
- Table "public.replication_metadata"
487
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
488
- ----------------+---------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
489
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | |
490
- relation | name | | not null | | plain | |
491
- options | text[] | | | | extended | |
492
- rewritemeornot | integer | | | | plain | |
486
+ Table "public.replication_metadata"
487
+ Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
488
+ ----------------+---------+-----------+----------+--------------------------------------------------+----------+-------------+------------- -+-------------
489
+ id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | | |
490
+ relation | name | | not null | | plain | | |
491
+ options | text[] | | | | extended | pglz | |
492
+ rewritemeornot | integer | | | | plain | | |
493
493
Indexes:
494
494
"replication_metadata_pkey" PRIMARY KEY, btree (id)
495
495
Options: user_catalog_table=false
0 commit comments