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.

Sign up for GitHub

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

Jump to bottom

Consider auto-undistributing foreign tables for TRUNCATE #5588

Closed
agedemenli opened this issue Dec 30, 2021 · 0 comments · Fixed by #5710
Closed

Consider auto-undistributing foreign tables for TRUNCATE #5588

agedemenli opened this issue Dec 30, 2021 · 0 comments · Fixed by #5710

Comments

@agedemenli
Copy link
Contributor

Truncating distributed foreign tables is not supported.
Users are recommended to do undistribute_table, then TRUNCATE, then distribute again.
We might consider doing this automatically

truncate foreign_table;
ERROR:  truncating distributed foreign tables is currently unsupported
HINT:  Consider undistributing table before TRUNCATE, and then distribute or add to metadata again
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
1 participant
@agedemenli