Need to run the following SQL on PostGIS-writer after last feature is written:
REFRESH MATERIALIZED VIEW db."myFirstView";
REFRESH MATERIALIZED VIEW db."mySecondView";
However when I add it to the SQL to Execute After in Navigator and WRITER-settings then it just complains relation doesnt exist. If I run the same SQL in a SQLExecutor on a second workspace afterwards it runs with no issues.
Is there another syntax when using the SQL to Execute after on the WRITER settings?