TimescaleDB 2.11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select extname from pg_extension;

extname

plpgsql

timescaledb

timescaledb_toolkit

SELECT 3

select installed_version from pg_available_extensions where name = 'timescaledb';

installed_version

2.11.1

SELECT 1

CREATE TABLE IF NOT EXISTS "Measurements" (
    "Id" SERIAL,-- PRIMARY KEY,
    "DeviceId" VARCHAR(255) NOT NULL,
    "SensorId" VARCHAR(255) NOT NULL,
    "Timestamp" TIMESTAMPTZ NOT NULL,
    "Temperature" DECIMAL(10, 2)
);

CREATE TABLE

--won't work because version 2.11<2.13 where this was introduced
SELECT create_hypertable('Measurements', by_range('Timestamp'));

ERROR:  function by_range(unknown) does not exist
LINE 2: SELECT create_hypertable('Measurements', by_range('Timestamp...
                                                 ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

--old way, but still case-sensitive
SELECT create_hypertable('Measurements', 'Timestamp');

ERROR:  relation "measurements" does not exist
LINE 2: SELECT create_hypertable('Measurements', 'Timestamp');
                                 ^

--old way, but still case-sensitive
SELECT create_hypertable('"Measurements"', 'Timestamp');

create_hypertable

(1,public,Measurements,t)

SELECT 1

insert into "Measurements" values
(default,'','',now(),0) returning *;

Id
DeviceId
SensorId
Timestamp
Temperature

1

2024-05-01 22:46:02.891889+00
0.00

INSERT 0 1

create table conditions (id int, time timestamp);
SELECT create_hypertable('conditions', 'time');

create_hypertable

(2,public,conditions,t)

SELECT 1