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

Mirrored Table schema changes #421

Closed
iskakaushik opened this issue Sep 26, 2023 · 1 comment
Closed

Mirrored Table schema changes #421

iskakaushik opened this issue Sep 26, 2023 · 1 comment
Assignees
@heavycrystal
Labels
peerdb-mirror
Milestone
oct 16 - oct 27

Comments

@iskakaushik
Copy link
Contributor

iskakaushik commented Sep 26, 2023 •
edited
Loading

DDL Propagation
ALTER TABLE ADD COLUMN  Replay the added column on the target side
ALTER TABLE ADD COLUMN DEFAULT Partially reflected is okay. In the destination, rows synced prior to the ADD COLUMN operation have null values in the newly-added column. Re-sync the table if you want to update the existing rows in the destination with the default value.
Don't allow ALTER TABLE DROP COLUMN Can lead to chaining issues.
@iskakaushik iskakaushik added this to the oct-2 to oct-13 milestone Sep 26, 2023
@heavycrystal
Copy link
Contributor

Closed by #368, #480 and #503

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@heavycrystal heavycrystal

Labels
peerdb-mirror
Projects
None yet
Milestone
oct 16 - oct 27
Development

No branches or pull requests
2 participants
@iskakaushik @heavycrystal