citusdata / citusdata/citus

cannot upgrade table to a reference table in mx

Open
#1,780 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

- created a distributed table with a single shard (in mx)
- run upgrade_to_reference table

```sql
set citus.shard_count to 1;
create table m1(a int, b int);
select create_distributed_table('m1', 'a');

select upgrade_to_reference_table('m1');
ERROR: cannot upgrade to reference table
DETAIL: Upgrade is only supported for statement-based replicated tables but "m1" is streaming replicated
```

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.