search

pgspider / jdbc_fdw

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

ERROR: type "varchar2" does not exist #28

Open edgarSbGroup opened 6 months ago

edgarSbGroup commented 6 months ago

When running import foreign schema test_schema from server server_test into schema_test; from an Oracle based system I get

[42704] ERROR: type "varchar2" does not exist

The script is trying to create a foreign table with varchar2

MinhLA1410 commented 2 months ago

@edgarSbGroup , Thank you for reporting

jdbc_fdw has never tested with Oracle, so we can't provide any more information. But here is limitation of jdbc_fdw We are open to any suggestions and can consider them for future improvements.