arkhipov / temporal_tables

Temporal Tables PostgreSQL Extension
BSD 2-Clause "Simplified" License
937 stars 47 forks source link

different set_system_time within one transaction #62

Open pauleckhardt opened 2 years ago

pauleckhardt commented 2 years ago

When using different set_system_time within one transaction, no rows are written to the history table. Example:

=> begin transaction
=*> select set_system_time('2022-01-01');
=*> insert into test (id) values (1);
=*> select set_system_time('2022-01-02');
=*> delete from test where id=1;
=*> select * from test;
(0 rows)
=*> select * from histtest;
(0 rows)