Re: BUG #18402: Attaching a new partition doesn't reuse the prebuilt index on said partition

CREATE TABLE master_2026 (LIKE master INCLUDING DEFAULTS INCLUDING

CONSTRAINTS);

ALTER TABLE master_2026 ADD CONSTRAINT master_2026_ck CHECK (millesime =

'2026');

DO 

$do$

BEGIN

      INSERT INTO master_2026 VALUES (generate_series(1,100000), '2026');

END

$do$;

CREATE UNIQUE INDEX CONCURRENTLY master_2026_pkey ON master_2026 (id,

millesime);

ALTER TABLE master ATTACH PARTITION master_2026 FOR VALUES IN ('2026');