Hello
This is me problem: fdw_test=# SELECT oracle_diag(); oracle_diag --------------------------------------------------------------------------------------------------------------- oracle_fdw 1.2.0, PostgreSQL 9.1.8, Oracle client 11.2.0.1.0, ORACLE_HOME=/opt/oracle/, TNS_ADMIN=/opt/oracle (1 row) In PostgreSQL: SELECT pg_backend_pid(); 5543 In a second session in the shell: ps -p5543 -oppid= 5290 As root or PostgreSQL OS user: cat /proc/5290/environ | xargs -0 -n1 LD_LIBRARY_PATH=/usr/lib:/opt/PostgreSQL/9.1/lib:/opt/oracle/instantclient:$LD_LIBRARY_PATH HOME=/opt/PostgreSQL/9.1 TNS_ADMIN=/opt/oracle PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/opt/PostgreSQL/9.1/bin:/usr/lib/postgresql/9.1/bin:/opt/PostgreSQL/9.1/bin/bin ORACLE_HOME=/opt/oracle DYLD_LIBRARY_PATH=/opt/oracle/instantclient:$ORACLE_HOME My error is: OCIEnvCreate ¿What is the solution? Please. Saludos, Gilberto Castillo La Habana, Cuba
--- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers