undistribute_table doesn't drop sequences on workers
Open
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
Assessment
This issue has not been assessed yet.