Skip to content

pg_rewrite 2.0.0

Latest
Compare
Choose a tag to compare
@df7cb df7cb released this 08 Aug 09:26
· 1 commit to master since this release
REL2_0_0

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.