pgspider / jdbc_fdw

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

Column names should be quoted #34

Open jw1u1 opened 5 months ago

jw1u1 commented 5 months ago

import foreign schema on Sybase ase fails due to syscolumns.offset column name, which has to be quoted.

jw1u1 commented 4 months ago

should be done in line 429 of file JDBCUtils.java: tmpColumnNamesList.add(tmpResultSet.getString("COLUMN_NAME"));

MinhLA1410 commented 4 months ago

Hi @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.