I am trying this interesting repo:
I create a partition table ,and use measurement.
CREATE TABLE measurement(
city_id int not null,
logdate date not null,
peaktemp int,
unitsales int
)partition by range(logdate);
select enable_ts_table('measurement');
Then I try to drop it (both cascade and no cascade have been tested):
DROP TABLE measurement CASCADE;
Then I create the same partition table, try to use ts_table, it doesn't work:
NOTICE: relation "template_public_measurement" already exists, skipping
ERROR: duplicate key value violates unique constraint "part_config_parent_table_pkey"
We have to delete it manually.
DELETE FROM part_config where part_config.parent_table ='public.measurement';
I am trying this interesting repo:
I create a partition table ,and use measurement.
Then I try to drop it (both cascade and no cascade have been tested):
Then I create the same partition table, try to use ts_table, it doesn't work:
We have to delete it manually.