field latest_version was introduced for time series
Especially with regard to FDO and caching, the introduction of a field holding the latest version of the data from one time series within the database is needed.
This database field is created via
ALTER TABLE timeseries
ADD COLUMN latest_version character(28) DEFAULT '000001.000000.00000000000000'::bpchar NOT NULL;
When introducing this database field, the metadata for already existing time series has to be adapted:
latest_timeseries
must be set to SELECT max(version) FROM data WHERE timeseries_id=nnnnn
.
Also, the python scripts for the REST API need to be adapted.
Edited by Sabine Schröder