Skip to content

Releases: cybertec-postgresql/pg_rewrite

pg_rewrite 2.0.0

08 Aug 09:26
REL2_0_0
Compare
Choose a tag to compare

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
    constraints 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.