Skip to main content
Question

REFRESH MATERIALIZED VIEW

  • September 23, 2014
  • 0 replies
  • 25 views

sigtill
Supporter
Forum|alt.badge.img+24
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?

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings