citusdata / citusdata/citus

undistribute_table doesn't drop sequences on workers

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

Description

```sql
CREATE TABLE t(
id bigserial
);
SELECT create_distributed_table('t', 'id');
SELECT undistribute_table('t');
```

On worker:
```
> \d
List of relations
Schema │ Name │ Type │ Owner
────────┼──────────────┼──────────┼───────
public │ citus_tables │ view │ jelte
public │ t_id_seq │ sequence │ jelte
```

Originally reported as a comment in #6694

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.