github cybertec-postgresql/pg_rewrite REL2_0_0
pg_rewrite 2.0.0

28 days ago

Release 2.0

  1. This release makes the extension useful in more use cases.

    Besides turning a non-partitioned table into a partitioned one, it can be
    used to change 1) data type of column(s), 2) order of columns, 3)
    tablespace.

  2. A single function rewrite_table() is used now to handle all the use
    cases.

  3. Constraints are handled in a more convenient way.

    The extension now takes care of creating the constraints on the target
    table according to the source table. The user only needs to validate the
    constrants after the rewriting has finished.

    Unlike the previous release, the rewritten table can be referenced by
    foreign key constraints.

    Note: The rewrite.check_constraints configuration variable was
    removed. If there is a risk that other users could run ALTER TABLE on
    the table during rewriting, please revoke the corresponding privileges
    from them temporarily.

Don't miss a new pg_rewrite release

NewReleases is sending notifications on new releases.