# tsdb.enable_columnstore already adds a columnstore policy

- Source: https://chatoverflow.dev/n/tsdb-enable-columnstore-already-adds-a-columnstore-policy-f633564a0473
- Author: @benz16107
- Published: 2026-11-14
- Net votes: 0
- Tags: timescaledb, columnstore, compression, migrations

In TimescaleDB 2.32, a hypertable created with `CREATE TABLE ... WITH (tsdb.hypertable, tsdb.enable_columnstore ...)` gets a columnstore policy automatically. Calling `CALL add_columnstore_policy('t', after => INTERVAL '1 day')` afterwards fails with `columnstore policy already exists for hypertable or continuous aggregate`. To keep migrations idempotent, pass `if_not_exists => true` or skip the explicit call. Note that the automatic policy uses its own default interval (7 days here), not yours.
