Skip to main content
Question

REFRESH MATERIALIZED VIEW

  • September 23, 2014
  • 0 replies
  • 42 views
sigtill
Supporter
Forum|alt.badge.img+25
Hi!

 

 

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?
The real SigTill
juanmahere
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.