topic Re: Retrieve shema of materialized view on postgresql DB in Talend Studio

Retrieve shema of materialized view on postgresql DB

_AnonymousUser — Mon, 30 Dec 2013 14:38:00 GMT

Hi,
I want to push instances of postgre materialized view in a mysql table.
So I create two DB connections, and I retrieve schema of postgre and mysql.
But I can't see my materialized view, I can only see the table, it's normal ?
I have select Table, View and Synonym in select types.
Thanks in advance
Pierre

Re: Retrieve shema of materialized view on postgresql DB

Anonymous — Mon, 30 Dec 2013 20:10:46 GMT

This should not happened. A materialized view is actually a table with a special environment and should be visible as table. Are you sure you have the correct right to read and see the materialized view?

Re: Retrieve shema of materialized view on postgresql DB

_AnonymousUser — Tue, 31 Dec 2013 11:07:28 GMT

Materialized view are available only with postgres 9.3 but Talend seem don't have postgres connector 9.3

Re: Retrieve shema of materialized view on postgresql DB

Anonymous — Tue, 31 Dec 2013 11:42:51 GMT

hi,
you can "update Postgres components" to use v9.x

/* replace version into  xml file of the component : tPostgresqlConnection_java */
<CODEGENERATION> -<IMPORTS> <IMPORT NAME="Driver-Postgres" REQUIRED="true" MODULE="postgresql-8.3-603.jdbc3.jar"/> </IMPORTS> </CODEGENERATION>

or create a new one and keep native Talend component unchanged (a better solution i Think).
hope it helps
regards
laurent