Backport to 2.15.x: #6903: Fix update triggers issue caused by decompression

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.

https://www.timescale.com/

Other

16.83k stars 852 forks source link

Backport to 2.15.x: #6903: Fix update triggers issue caused by decompression #6964

Closed antekresic closed 1 month ago

antekresic commented 1 month ago

Update triggers were broken due to snapshot manipulation and usage of dynamic snapshots for scanning tuples. Using a static snapshot guarantees we cannot see tuples that would be invisible during an update trigger.

Fixes https://github.com/timescale/timescaledb/issues/6858