Hello,
with pg10 you have syntax
ALTER TABLE year_total DETACH PARTITION year_total_2015;
ALTER TABLE year_total ATTACH PARTITION year_total_2015_new
FOR VALUES ...
See https://stream.boxwatch.ru/docs/current/static/ddl-partitioning.html
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html