pgroll icon indicating copy to clipboard operation
pgroll copied to clipboard

Add support for adding generated/identity columns to existing tables

Open kvch opened this issue 9 months ago • 1 comments

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.

kvch avatar Jan 29 '25 11:01 kvch