search

pgspider / jdbc_fdw

JDBC Foreign Data Wrapper for PostgreSQL
Other
58 stars 20 forks source link

IMPORT FOREIGN SCHEMA: exclude System Tables #36

Open jw1u1 opened 2 months ago

jw1u1 commented 2 months ago

getTables(null, null, "%", null) includes System Tables, and this fails on Sybase ASE. Please restrict it on "TABLE" and "VIEW" (4th Parameter) in line 402 of JDBCUtils.java: ResultSet tmpResultSet = md.getTables(null, null, "%", null);

MinhLA1410 commented 1 month ago

Thank you @jw1u1 ,

JDBC FDW has not been tested with Sybase ASE. We do not have special experience and knowledge using Sybase ASE. But to ensure the best outcomes and continuous improvement, we would like to know if you have any additional resources or information. We are open to any suggestions and can consider them for future improvements.