Skip to content

Add a note about backporting columns with default

What does this MR do?

Add a note about backporting columns with default

PostgreSQL 11 is required starting from 12.10. Before PostgreSQL 11, adding a column requires a full table write, so if the table has a considerable number of records, this causes for the table to be unavailable until the column is added (which can take a while).

This commits adds a note on 'Add Column with Default' to state backporting a column with default needs to use add_column_with_default, and if a large table is involved, it should not add a default

Related issues

Related to #207820 (closed) and to !32375 (comment 344716016)

Author's checklist (required)

When applicable:

Review checklist

All reviewers can help ensure accuracy, clarity, completeness, and adherence to the Documentation Guidelines and Style Guide.

1. Primary Reviewer

  • Review by a code reviewer or other selected colleague to confirm accuracy, clarity, and completeness. This can be skipped for minor fixes without substantive content changes.

2. Technical Writer

  • Optional: Technical writer review. If not requested for this MR, must be scheduled post-merge. To request for this MR, assign the writer listed for the applicable DevOps stage.

3. Maintainer

  1. Review by assigned maintainer, who can always request/require the above reviews. Maintainer's review can occur before or after a technical writer review.
  2. Ensure a release milestone is set.
  3. If there has not been a technical writer review, create an issue for one using the Doc Review template.
Edited by 🤖 GitLab Bot 🤖

Merge request reports