Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot create citus table if column defaults to a user created sequence in MX #3884

Closed
onurctirtir opened this issue Jun 9, 2020 · 0 comments · Fixed by #4914
Closed

Cannot create citus table if column defaults to a user created sequence in MX #3884

onurctirtir opened this issue Jun 9, 2020 · 0 comments · Fixed by #4914
Labels

Comments

@onurctirtir
Copy link
Member

onurctirtir commented Jun 9, 2020

If we have a table which has a column defaulting to a sequence created by CREATE SEQUENCE command, we get the following as we don't propagate sequences to worker nodes by default.

Along with the problem defined by the title of the issue, same problem also occurs when we try to sync metadata to a worker node after creating such a citus table. An example with reference tables:

CREATE SEQUENCE sequence;
CREATE TABLE reference_table (a int default nextval('sequence'));
SELECT create_reference_table('reference_table');
SELECT start_metadata_sync_to_node('localhost', 9701);
ERROR:  relation "public.sequence" does not exist
CONTEXT:  while executing command on localhost:9701
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants