Skip to content

Creation works but Deletion is not working after successful job run #700

Answered by keithf4
Rammurthy5 asked this question in Q&A

You must be logged in to vote

Do you have any data the table? Maintenance generally doesn't do anything when a table is completely empty of all data (except if you have infinite_time_partitions set to true in part_config. I tested it out and it did nothing when there was no data. As soon as I inserted some data, then both new table creation and retention worked

github700=# create table db_owner.emp (name varchar(50), uuid uuid default gen_random_uuid(), tscreated timestamp without time zone not null) partition by range (tscreated);
CREATE TABLE
github700=# alter table db_owner.emp add primary key (uuid, tscreated);
ALTER TABLE

github700=# select partman.create_parent('db_owner.emp', 'tscreated', '1 hour', p_start_par…

Replies: 1 comment 2 replies

You must be logged in to vote
2 replies
@Rammurthy5

@keithf4

Answer selected by Rammurthy5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants