Category: Uncategorized
-
Working with TimescaleDB in Continuous Integration: Automating Materialized View Creation
If you’re integrating TimescaleDB into your CI/CD pipeline, you might have encountered a common issue when attempting to create a materialized view directly through your application code. Specifically, the error “ERROR: CREATE MATERIALIZED VIEW … WITH DATA cannot run inside a transaction block” can be a major stumbling block. Let’s explore how you can work…