I am trying to start a scheduled automation to run a refresh script daily, but it is just not working in FME.
Trying to run:
REFRESH MATERIALIZED VIEW CONCURRENTLY gis.map_filters_mvw WITH DATA;
Thank you,
Kevin
Userlevel 2
+19
- Contributor
- 141 replies
-
5 May 2022
Can you provide a little more info. Are you using desktop workbench or fme server. Please add some screen shots?
+2
- Participant
- 10 replies
-
5 May 2022
Ah good point, I'm using desktop currently but would eventually like to automate on the server. The materialized view is on postgres database. I've just been trying input, sql tranformers with the code above and outputs but it just won't work.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.