0.7.1 (2017-11-29)

High-level changes

• Fix to the migration script for those coming from 0.6.1 (or earlier)
• Fix edge case in drop_chunks when hypertable uses TIMESTAMP type
• Query planning improvements & fixes
• Permission fixes and support SET ROLE functionality

Notable commits

• [717299f] Change time handling in drop_chunks for TIMESTAMP times
• [d8ec285] Do not append-optimize plans with result relations (DELETE/UPDATE)
• [30b72ec] Handle empty append plans in ConstraintAwareAppend
• [b35509b] Permission fixes and allow SET ROLE

Thanks

• @shaneodonnell for reporting a bug with empty append plans in ConstraintAwareAppend
• @ryan-shaw for reporting a bug with query plans involving result relations and reporting an issue with our 0.6.1 to 0.7.0 migration script

0.7.0 (2017-11-21)

Please note: This update may take a long time (minutes, even hours) to
complete, depending on the size of your database

High-level changes

• Initial PostgreSQL 10 support. TimescaleDB now should work on both PostgreSQL 9.6 and 10. As this is our first release supporting PG10, we look forward to community feedback and testing. Some release channels, like Ubuntu & RPM-based distros will remain on 9.6 for now
• Support for CLUSTER on hypertables to recursively apply to chunks
• Improve constraint handling of edge cases for DATE and TIMESTAMP
• Fix range_start and range_end to properly handle the full 32-bit int space
• Allow users to specify their desired partitioning function
• Enforce NOT NULL constraint on time columns
• Add testing infrastructure to use Coverity and test PostgreSQL regression tests in TimescaleDB
• Switch to the CMake build system for better cross-platform support
• Several other bug fixes, cleanups, and improvements

Notable commits

• [13e1cb5] Add reindex function
• [6594018] Handle when create_hypertable is invoked on partitioned table
• [818bdbc] Add coverity testing
• [5d0cbc1] Recurse CLUSTER command to chunks
• [9c7191e] Change TIMESTAMP partitioning to be completely tz-independent
• [741b256] Mark IMMUTABLE functions as PARALLEL SAFE
• [2ffb30d] Make aggregate serialize and deserialize functions STRICT
• [c552410] Add build target to run the standard PostgreSQL regression tests
• [291050b] Change DATE partitioning to be completely tz-independent
• [ca0968a] Make all partitioning functions take anyelement argument
• [a4e1e32] Change range_start and range_end semantics
• [2dfbc82] Fix off-by-one error on range-end
• [500563f] Add support for PostgreSQL 10
• [201a948] Check that time dimensions are set as NOT NULL.
• [4532650] Allow setting partitioning function
• [4a0a0d8] Fix column type change on plain tables
• [cf009cc] Avoid string conversion in hash partitioning
• [8151098] Improve update testing by adding a rerun test
• [c420c11] Create a catalog entry for constraint-backed indexes
• [ec746d1] Add ability to run regression test locally
• [44f9fec] Add analyze to parallel test for stability
• [9e0422a] Fix bug with pointer assignment after realloc
• [114fa8d] Refactor functions used to recurse DDL commands to chunks
• [b1ec4fa] Refactor build system to use CMake

Thanks

• @jgraichen for reporting an issue with drop_chunks not accepting BIGINT
• @nathansgreen for reporting an edge case with constraints for TIMESTAMP
• @jonmd for reporting a similar edge case for DATE
• @jwdeitch for a PR to cover an error case in PG10

0.6.1 (2017-11-07)

High-level changes

• Fix several memory bugs that caused segfaults
• Fix bug when creating expression indexes
• Plug a memory leak with constraint expressions
• Several other bug fixes and stability improvements

Notable commits

• [2799075] Fix EXPLAIN for ConstraintAware and MergeAppend
• [8084594] Use per-chunk memory context for cached chunks
• [a13d9de] Do not convert tuples on insert unless needed
• [da09f24] Limit growth of range table during chunk inserts
• [85dee79] Fix issue with creating expression indexes
• [844ff7f] Fix memory leak due to constraint expressions.
• [e90d3ee] Consider precvious CIS state in copy FROM file to rel
• [56d632f] Fix bug with pointer assignment after realloc
• [f97d624] Make event trigger creation idempotent

Thanks

• @jwdeitch for submitting a patch to correct behavior in the COPY operation
• @jgraichen for reporting a bug with expression indexes
• @ziXet for reporting a memory leak
• @djk447 for reporting a bug in EXPLAIN with ConstraintAware and MergeAppend

0.6.0 (2017-10-12)

High-level changes

• Fix bugs where hypertable-specific handlers were affecting normal Postgres tables.
• Make it so that all TimescaleDB commands can run as a normal user rather than a superuser.
• Updates to the code to make the extension compileable on Windows; future changes will add steps to properly build.
• Move time_bucket functions out of public schema (put in schema where extension is).
• Several other bugs fixes.

Notable commits

• [1d73fb8] Fix bug with extension starting too early.
• [fd390ec] Fix chunk index attribute mismatch and locking issue
• [430ed8a] Fix bug with collected commands in index statement.
• [614c2b7] Fix permissions bugs and run tests as normal user
• [ce12104] Fix "ON CONFLICT ON CONSTRAINT" on plain PostgreSQL tables
• [4c451e0] Fix rename and reindex bugs when objects are not relations
• [c3ebc67] Fix permission problems with dropping hypertables and chunks
• [040e815] Remove truncate and hypertable metadata triggers
• [5c26328] Fix INSERT on hypertables using sub-selects with aggregates
• [b57e2bf] Prepare C code for compiling on Windows
• [a2bad2b] Fix constraint validation on regular tables
• [fb5717f] Remove explicit schema for time_bucket
• [04d01ce] Split DDL processing into start and end hooks

Thanks

• @oldgreen for reporting time_bucket being incorrectly put in the public schema and pointing out permission problems
• @qlandman for reporting a bug with INSERT using sub-selects with aggregates
• @min-mwei for reporting a deadlock issue during INSERTs
• @ryan-shaw for reporting a bug where the extension sometimes used pg_cache too soon

0.5.0 (2017-09-20)

Important note: This upgrade may take a while depending on your data size and whether you have primary, unique, or a few other types of indexes that weren't previously correctly propagated down to chunks.

High-level changes

• Improved support for primary-key, foreign-key, unique, and exclusion constraints.
• New histogram function added for getting the frequency of a column's values.
• Add support for using DATE as partition column.
• chunk_time_interval now supports INTERVAL data types
• Block several unsupported and/or dangerous operations on hypertables and chunks, including dropping or otherwise altering a chunk directly.
• Several bug fixes throughout the code.

Notable commits

• [afcb0b1] Fix NULL handling in first/last functions.
• [d53c705] Add script to dump meta data that can be useful for debugging.
• [aa904fa] Block adding constraints without a constraint name
• [a13039f] Fix dump and restore for tables with triggers and constraints
• [8cf8d3c] Improve the size utils functions.
• [2767548] Block adding constraints using an existing index
• [5cee104] Allow chunk_time_interval to be specified as an INTERVAL type
• [6232f98] Add histogram function.
• [2380033] Block ALTER TABLE and handle DROP TABLE on chunks
• [72d6681] Move security checks for ALTER TABLE ALTER COLUMN to C
• [19d3d89] Handle changing the type of dimension columns correctly.
• [17c4ba9] Handle ALTER TABLE rename column
• [66932cf] Forbid relocating extension after install.
• [d2561cc] Add ability to partition by a date type
• [48e0a61] Remove triggers from chunk and chunk_constraint
• [4dcbe61] Add support for hypertable constraints

Thanks

• @raycheung for reporting a segfault in first/last
• @meotimdihia, @noyez, and @andrew-blake for reporting issues with UNQIUE and other types of constraints

0.4.2 (2017-09-06)

High-level changes

• Provide scripts for backing up and restoring single hypertables

Notable commits

• [683c078] Add backup/restore scripts for single hypertables

0.4.1 (2017-09-04)

High-level changes

• Bug fix for a segmentation fault in the planner
• Shortcut when constraint-aware append excludes all chunks
• Fix edge case with negative timestamps when points fell right on the boundary
• Fix behavior of time_bucket for DATE types by not converting to TIMESTAMPTZ
• Make the output of chunk_relation_size consistent

Notable commits

• [50c8c4c] Fix possible segfault in planner
• [e49e45c] Fix failure when constraint-aware append excludes all chunks
• [c3b6fb9] Fix bug with negative dimension values
• [3c69e4f] Fix semantics of time_bucket on DATE input
• [0137c92] Fix output order of chunk dimensions and ranges in chunk_relation_size.
• [645b530] Convert inserted tuples to the chunk's rowtype

Thanks

• @yadid for reporting a segfault (fixed in 50c8c4c)
• @ryan-shaw for reporting tuples not being correctly converted to a chunk's rowtype (fixed in 645b530)

0.4.0 (2017-08-21)

High-level changes

• Exclude chunks when constraints can be constifyed even if they are
  considered mutable like NOW().
• Support for negative values in the dimension range which allows for pre-1970 dates.
• Improve handling of default chunk times for integral date times by forcing it to be explicit rather than guessing the units of the time.
• Improve memory usage for long-running COPY operations (previously it would grow unbounded).
• VACUUM and REINDEX on hypertables now recurse down to chunks.

Notable commits

• [139fe34] Implement constraint-aware appends to exclude chunks at execution time
• [2a51cf0] Add support for negative values in dimension range
• [f2d5c3f] Error if add_dimension given both partition number and interval length
• [f3df02d] Improve handling of non-TIMESTAMP/TZ timestamps
• [6a5a7eb] Reduce memory usage on long-running COPY operations
• [953346c] Make VACUUM and REINDEX recurse to chunks
• [55bfdf7] Release all cache pins when a transaction ends

0.3.0 (2017-07-31)

High-level changes

• "Upserts" are now supported via normal ON CONFLICT DO UPDATE/ON CONFLICT DO NOTHING syntax. However, ON CONFLICT ON CONSTRAINT is not yet supported.
• Improved support for user-defined triggers on hypertables. Now handles both INSERT BEFORE and INSERT AFTER triggers, and triggers can be named arbitrarily (before, a _0_ prefix was required to ensure correct execution priority).
• TRUNCATE on a hypertable now deletes empty chunks.

Notable commits

• [23f9d3c] Add support for upserts (ON CONFLICT DO UPDATE)
• [1f3dcd8] Make INSERTs use a custom plan instead of triggers
• [f23bf58] Remove empty chunks on TRUNCATE hypertable.

0.2.0 (2017-07-12)

High-level changes

• Users can now define their own triggers on hypertables (except for INSERT AFTER)
• Hypertables can now be renamed or moved to a different schema
• Utility functions added so you can examine the size hypertables, chunks, and indices

Notable commits

• [83c75fd] Add support for triggers on hypertables for all triggers except INSERT AFTER
• [e0eeeb9] Add hypertable, chunk, and indexes size utils functions.
• [4d2a65d] Add infrastructure to build update script files.
• [a5725d9] Add support to rename and change schema on hypertable.
• [142f58c] Cleanup planner and process utility hooks