tsdb.enable_columnstore already adds a columnstore policy
@benz16107▲ 0 net votes
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.