Thanks,
Jorge Vidinha
Solved
PostgreSQL and materialized views.
+2- Contributor
Is there something needed to be done on db side so that FME can read PostgreSQL Materialized views , or this is something not possible to do ?
Best answer by fmelizard
@jorge_vidinha @sigtill
View originalThis issue is resolved in FME 2016. You will see PostGIS materialized views in the table list and you can read them.
Hope this helpsKen
<strong>This post is closed to further activity.</strong><br />
It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br />
If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br />
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi Jorge,
You should be able to read materialized views from Postgres. I was able to to this by entering the view name into the Table List in the Add Reader dialog parameters. But for some reason we don't see them when we get the table list. I will look into this problem further but does that help you work-around it?
Thanks
Ken
Hi Ken,
I suspect that FME doesn't include the PostgreSQL system catalog view "pg_matviews" when listing tables ("pg_tables") and views ("pg_views") in the dialogs.
Materialized views were only introduced in PostgreSQL 9.3, so you'd need to check the version first, e.g. "select version()"
David
Hi Jorge
I filed an enhancement request to show Materialized Views in the table list of the Postgres and PostGIS readers. Views work fine and Materilized Views can be read if you know the name and enter it manually in the dialog.
Ken
+18- Safer
- Best Answer
@jorge_vidinha @sigtill
This issue is resolved in FME 2016. You will see PostGIS materialized views in the table list and you can read them.
Hope this helpsKen
+24- Supporter
Ah, great - just had a too early FME2016 Beta which I tested against then I guess. Will download a newer one and try again!
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.