Ruslan Fomkin

@JLockerman Thank you for reporting! Am I correct that the chunk, which gets the trigger error, is compressed, i.e., the issue is in the user unfriendly error message?

Continues aggregate expects single hypertable in the from clause. Views, joins, subqueries are not supported. See the [docs](https://docs.timescale.com/latest/api#continuous_aggregate-create_view)

@Knudian Thank you for your proposal. If you want to submit it as PR, then you can prepare a proper PR from your fork. It will be important to add...

For consistency, it might be good to implement duplicate elimination for raw schema too.

The test can be continuation of the existing tests. For example, it inserts new data with duplicates after the existing test and then selects data from the table and compares...

This issue can be experienced in old docs, e.g., https://docs.timescale.com/v1.3/getting-started/installation/azure/installation-windows-azure I am not sure if it is worth to fix, since Azure is removed from the list in the later...

@swiffer It is not supported for regular table. From clause can contain just single hypertable.

Thank you for requesting the feature. We will followup.

@kvroegop Thank you for the detailed report. Can you check permissions on TimescaleDB files in the lib? Can you check if giving a lot of permissions will solve the problem?

Thanks for checking if it is a permission error. Can you look if discussion in https://github.com/timescale/timescaledb/issues/1458 helps?