Issue exporting Materialized view using script

[srinilakshmi]

Hi Darold,

I am working on migrating SQL Server scripts to PostgreSQL using windows version of Ora2PG with scripts migration (offline due to restrictions in our company).

I am having issue with exporting Materialized views, getting an error. please find the attached screenshot

and when get chance can you look at the other issue we had conversation #1828

Any help for the above is really helpful and I am desperately need help with these.

TIA

[wisdomonezxy]

only a test

[srinilakshmi]

Not following.

[srinilakshmi]

@darold and @wisdomonezxy
Can someone explain what it means by test? Is that functionality only available in testing?

[darold]

@srinilakshmi, you write "not following" so I have understood that this issues was discarded.

I have done some work recently to better support migration of input DDL script for SQL Server but there's less possible translation than for Oracle. Anyway materialized view are not supported yet. If you can post DDL samples I can try to implements it.

[srinilakshmi]

@darold sorry for the confusion.

Here is the sample Materailized view for Oracle db in DDL script. Please let me know.

CREATE MATERIALIZED VIEW "MD_SAMPLE_VIEW" ("PROJECT_ID", "CONNECTION_ID", "CONNECTION_NAME")
SEGMENT CREATION DEFERRED
ORGANIZATION HEAP PCFTREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS LOGGING NO INMEMORY
BUILD IMMEDIATE
USING INDEX
REFRESH FORCE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONMSTRAINTS DISABLE ON QUERY COPUTATION DISABLE QUERY REWRITE
AS SELECT PROJECT_ID, CONNECTION_ID, CONNECTION_NAME
from MD_REGEX_SCHEMA_MVIEW
group by PROJECT_ID, CONNECTION_ID, CONNECTION_NAME;

COMMENT ON MATERIALIZED VIEW "MD_SAMPLE_VIEW" IS 'sample materialized view';