crate / crate/cratedb-toolkit

[RETENTION] Prevent multiple strategies operating on the same table

Open
#26 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
10
Forks
5
Avg merge
7d 5h
Merged PRs (30d)
7

Description

### About
The idea behind the composite primary key `PRIMARY KEY ("strategy", "table_schema", "table_name")` was to prevent duplicate strategies on the same table. Too bad we don't have `UNIQUE` constraints in CrateDB.

### Regression?
> Is there elsewhere in the code a check to prevent duplicates (i.e., for the same table, one entry with `DELETE` and 3 days retention, and another with `DELETE` and 5 days retention on the same table)?

_Originally posted by @hammerhead in https://github.com/crate-workbench/cratedb-retention/pull/20#discussion_r1250850198_

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.