• Prohibit execution of query DELETE FROM partitioned_table_1 USING partitioned_table_2... if it touches more than 1 partition of partitioned_table_1;
• Prohibit execution of query UPDATE partitioned_table_1 FROM partitioned_table_2... if it touches more than 1 partition of partitioned_table_1;
• Support for PostgreSQL 10 RC 1.

See wiki page for details.

• Fixed crash on RESET ALL (issue #121);

• Fixed WHERE conditions that point to gaps between partitions (issue #117);
• Restored compatibility with pg_repack (issue #118);
• Fixed MSVC builds (Windows).

• Disabled dangerous optimizations for UPDATE & DELETE on PostgreSQL 9.5 (issue #110);
• Fixed DELETE FROM single_table USING partitioned_table (issue #111);
• Fixed EXPLAIN (VERBOSE) INSERT INTO partitioned_table (issue #112);

• Fix partition pruning in UPDATE and DELETE queries (issues #98, #105);
• Improved UPDATE and DELETE on a missing key (mentioned in issue #104);
• Compatibility fix for PostgreSQL 9.5.0 – 9.5.5 and 9.6.0 – 9.6.1;
• Support for PostgreSQL 10 beta2;

• Fixed queries with mirrored clauses (e.g. 200 > val instead of val < 200);
• Fixed crashes on utility statements (e.g. drop index concurrently);
• Fixed crashes of queries involving RuntimeAppend if a column was dropped;
• Fixed builds on MSVC (86e280cbb6c7);
• Support for upcoming Postgres Pro 10;

NOTE: this release has been re-tagged for META.json (PGXN).

Improvements:

• Partitioning by expression;
• Partitioning by composite key;
• Support for PostgreSQL 10 beta1;
• Partitioning dispatch cache is now lazy (improved performance);
• Fixed ORDER / GROUP BY + RuntimeAppend (issue #84);
• Fixed quals push-down in LEFT JOIN (issue #91);
• Fixed typo in check_boundaries() (issue #92);
• Fixed expr op ANY (...), expr op ALL (...) (e.g. val < ANY (array[1,2,3])).
• New function create_range_partitions(..., bounds_array, ...) (issue #30);
• New function generate_range_bounds();
• New view pathman_cache_stats;
• Show Prune by: _expression_ for Runtime[Merge]Append;
• More optimizations for expr IN (...), expr op ANY (...), expr op ALL (...);
• Auto-naming sequence will be dropped if CASCADE option is specified;
• Stability-related fixes;

Other changes:

• Removed create_partitions_from_range();
• Introduced Wiki.

• Compatibility fixes for Postgres Pro Standard 9.6.3.1 (1C);
• Fix wholerow references (table’s name acts as type);

• Improved check for shared_preload_libraries (issue #82);
• Set proper tuple descriptor in COPY command in case of tuple conversion (issue #87);
• Fix join clause handling;

• Infinite bounds for RANGE partitioning: (-inf, X) ... (Y, +inf);
• New function set_interval(relation, value);
• Validate RANGE interval (restrict trivial values);
• Rebuild COPYed / INSERTed tuples for partitions with different column set (e.g. append_range_partition() after some column has been dropped, issue #74);
• Pass schema names to partition initialization callback (issue #76);
• Fix inability to upgrade PostgreSQL cluster (issue #75);
• Merge arbitrary amount of RANGE partitions (function merge_range_partitions(partitions));
• Stability-related fixes;