Solved

PostgreSQL and materialized views.

Forum|Forum|10 years ago
March 31, 2015
6 replies
78 views

+2

jorge_vidinha
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 ?

Thanks,

Jorge Vidinha

Best answer by fmelizard

@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

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.

K

ken
Forum|Forum|10 years ago
March 31, 2015

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

Upvote

david_r
Forum|Forum|10 years ago
March 31, 2015

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

Upvote

K

ken
Forum|Forum|10 years ago
April 1, 2015

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