citusdata / citusdata/citus

Disappearing comments after undistributing table

Open
#6,768 3 comments 2 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.