Postgres 11

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table stats_to_institution
(
  code text,
  some_value integer
)
partition by range (code);

CREATE TABLE pqr_272 PARTITION OF stats_to_institution FOR VALUES FROM ('270000000') TO ('280000000');

CREATE TABLE

CREATE TABLE

-- works
insert into stats_to_institution (code, some_value)
values 
  ('270000001', 1),
  ('270000002', 2);

INSERT 0 2

select *
from stats_to_institution;

code
some_value

270000001
1

270000002
2

SELECT 2

-- fails because no partition for this value
insert into stats_to_institution (code, some_value)
values 
  ('290000001', 29);

ERROR:  no partition of relation "stats_to_institution" found for row
DETAIL:  Partition key of the failing row contains (code) = (290000001).

alter table stats_to_institution detach partition pqr_272;

alter table stats_to_institution attach partition pqr_272 for values FROM ('270000000') TO ('300000000');

ALTER TABLE

ALTER TABLE

-- works now because no partition for this value
insert into stats_to_institution (code, some_value)
values 
  ('290000001', 29);

INSERT 0 1

select *
from stats_to_institution;

code
some_value

270000001
1

270000002
2

290000001
29

SELECT 3