正如在Orafce中提到的Install.orafunc：

• ..在数据库中安装Orafce函数，或者使用pgAdmin SQL工具运行orafce.sql脚本。

我尝试在pgAdmin sql编辑器中运行orafce–3.0.sql。这给我错误 ERROR: could not access file "MODULE_PATHNAME": No such file or directory.

您所说的模块路径是什么意思？

安装程序：

strawberry perl with DBD::Oracle

postgresql 9.3

pgAdmin III

未完全安装：

ora2pg

我尝试安装ora2pg …有问题。

H:\PostgreSQL\ora2pg-12.1>perl makefile.pl
Unparsable version '' for prerequisite DBD::Oracle at makefile.pl line 553
Generating a dmake-style Makefile
Writing Makefile for Ora2Pg
Writing MYMETA.yml and MYMETA.json
Done...

H:\PostgreSQL\ora2pg-12.1>dmake && dmake install
"Installing default configuration file (ora2pg_dist.conf) to C:\ora2pg"
Appending installation info to C:\strawberry\perl\lib/perllocal.pod
dmake:  Warning: -- Target [install] was made but the time stamp has not been up
dated.

建议的解决方案：

我从okbob github下载了orafce的副本
将文件解压缩到文件夹D:/Postgresql/orafce-master

我 只 复制以下文件

orafce–未打包–3.0.6.sql

orafce–3.0.6.sql

orafce.control

到文件夹 C:\Program Files\PostgreSQL\9.3\share\extension

然后，我尝试在pgAdmin III sql工具中运行此命令。

CREATE EXTENSION orafce;

我收到此警告和错误。

[WARNING ] CREATE EXTENSION orafce ERROR: syntax error in file "C:/Program Files/PostgreSQL/9.3/share/extension/orafce.control" line 1, near end of line

我检查了orafce.control内容。它具有此配置。

# intarray extension
comment = 'Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS'
default_version = '3.0.6'
module_pathname = '$libdir/orafunc'
relocatable = false`

我无法通过这堵墙。似乎是什么问题？