citusdata / citusdata/citus

create_distributed_table needs dependent sequence owned by the user

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

Description

Although PG allows to create table even if the dependent sequence is not owned by the user, Citus enforces it.

```sql
CREATE SEQUENCE my_seq;

CREATE USER test_user;
SELECT run_command_on_workers($$CREATE USER test_user;$$);

SET ROLE test_user;
CREATE TABLE dist_table(a int, b int DEFAULT nextval('my_seq'));

SELECT create_distributed_table('dist_table', 'a');
ERROR: must be owner of sequence my_seq
```

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.