[5.0 Upgrade] Database history tables upgraded: No, ERROR: operation not supported

[bix]

Hi,
I've upgraded from 4.4 to 5.0
PostgreSQL 11.6
TimescaleDB version 1.6.0

I am trying to apply a patch double.sql and I get an error

zabbix=# \i double.sql
psql:double.sql:7: ERROR: operation not supported on hypertables that have compression enabled
psql:double.sql:10: ERROR: operation not supported on hypertables that have compression enabled

How to fix the problem?

[bix]

Old data deleted

alter table history set (timescaledb.compress=false);
-Ok

ALTER TABLE trends set (timescaledb.compress=false);
ERROR: constraint trends_pkey requires column itemid to be a segment_by or order_by column for compression
HINT: Only segment by and order by columns can be used in constraints on hypertables that are compressed.

How to fix the problem?

[bix]

Thanks. Problem solved.