citusdata / citusdata/citus

Failed to undistribute table on generated primary key column

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

Description

Given following table, Citus is able to create distributed table but failed to revert into undistributed one.

```
create table gis.address
(
address_id bigint generated always as identity (minvalue 1000000000)
constraint address_pk
primary key,
place_geom geometry(Point, 4326),
query_name text,
place_name text,
place_address text
);

alter table gis.address
owner to postgres;

create index address_address_id_index
on gis.address (address_id);

create index address_query_name_index
on gis.address (query_name);

```

SELECT create_distributed_table('gis.address', 'address_id'); -- SUCCESS
SELECT undistribute_table('gis.address'); -- FAILED
-- [0A000] ERROR: cannot complete operation on a table with identity column

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.