Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();

version

PostgreSQL 16.6 (Debian 16.6-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit

SELECT 1

CREATE TABLE measurement (
    city_id         int not null,
    logdate         date not null,
    peaktemp        int,
    unitsales       int
) PARTITION BY RANGE (logdate);

-- Create partitions
CREATE TABLE measurement_y2020 PARTITION OF measurement
    FOR VALUES FROM ('2020-01-01') TO ('2021-01-01');
CREATE TABLE measurement_y2021 PARTITION OF measurement
    FOR VALUES FROM ('2021-01-01') TO ('2022-01-01');

CREATE TABLE

CREATE TABLE

CREATE TABLE

-- CREATE INDEX CONCURRENTLY 
CREATE INDEX CONCURRENTLY measurement_logdate_idx ON measurement (logdate);

ERROR:  cannot create index on partitioned table "measurement" concurrently

SELECT * FROM pg_indexes WHERE tablename LIKE 'measurement%';

schemaname
tablename
indexname
tablespace
indexdef

SELECT 0