Disappearing comments after undistributing table
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
Hi, we have a problem with disappearing comments during development, if distributed table is undistributed.
```
CREATE SCHEMA test;
CREATE TABLE test.table_1
(
id bigserial,
code varchar(200) not null,
name varchar(200),
date_created timestamp with time zone default NOW() not null,
active boolean default true,
CONSTRAINT table_1_pkey PRIMARY KEY (id)
)
WITH (autovacuum_enabled = TRUE);
comment on table test.table_1 is 'Table 1';
comment on column test.table_1.id is 'table id';
comment on column test.table_1.code is 'table code';
comment on column test.table_1.name is 'table name';
comment on column test.table_1.date_created is 'table date_created';
comment on column test.table_1.active is 'table active';
SELECT create_distributed_table('test.table_1', 'id');
select obj_description('test.table_1'::regclass); -- has comment
select undistribute_table('test.table_1');
SELECT create_distributed_table('test.table_1', 'id');
select obj_description('test.table_1'::regclass); -- has no comment
```
Contributor guide
Assessment
This issue has not been assessed yet.