ERROR: IMPORT FOREIGN SCHEMA

laurenz / oracle_fdw

PostgreSQL Foreign Data Wrapper for Oracle

http://laurenz.github.io/oracle_fdw/

Other

486 stars 156 forks source link

ERROR: IMPORT FOREIGN SCHEMA #702

Open bossdu15000 opened 3 weeks ago

bossdu15000 commented 3 weeks ago

postgresql versions: 15.8 instant oracle client versions: 19.20 oracle_fdw versions: 2.7.0

Good morning, oracle_fdw version 2.7.0 has a problem.

SQL command: IMPORT FOREIGN SCHEMA "[ORACLE_SCHEMA]" FROM SERVER [SERVER_POSTGRES] INTO [SCHEMA_POSTGRES];

this command in 2.6.0 imports all the tables of the oracle schema. in 2.7.0 it ignores certain tables. out of 3000 tables oracle_fdw 2.7.0 ignored 3 tables.

mkgrgis commented 3 weeks ago

@bossdu15000 , could you please share type of ignored tables or other metadata, which differs from normal imported tables ?

laurenz commented 2 weeks ago

Right, it would be useful to know what those 3 objects are. Views? Materialized views? Is there anything peculiar about the table name in Oracle? Anything else that stands out?

There were some changes in 2.7.0 in this area, but they shouldn't have such an effect. You might have discovered a bug.