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

Add support for adding generated/identity columns to existing tables #638

Open
kvch opened this issue Jan 29, 2025 · 1 comment
Open

Add support for adding generated/identity columns to existing tables #638

kvch opened this issue Jan 29, 2025 · 1 comment
Labels
enhancement New feature or request

Comments

@kvch
Copy link
Contributor

kvch commented Jan 29, 2025

Right now pgroll only supports adding generated columns to new tables. When you add a new generated column, PostgreSQL has to update all rows in the table. This can be resource intensive and may lead to downtime.

We must add a proper migration to support this case. We can either improve add_column operation or introduce a new operation.

@andrew-farries
Copy link
Collaborator

#637 contains removed test cases that could be useful for when we implement this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants