python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - oracle-fdw

error: could not load library ~ undefined symbol: errcontext

First, I installed oracle_fdw and oracle instant client. Second, I set LD_LIBRARY_PATH and ORACLE_HOME (~/.bash_profile). Finally, I ran the make command in the oracle_fdw directory. I installed the o...
test-img

서 민진

linux

postgresql

centos7

oracle-fdw

Votes: 0

Answers: 1

Latest Answer

oracle_fdw version : 2.4.0 If you run make using the latest version of oracle_fdw, the following error occurs. $ sudo make clean $ sudo make gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions...
test-img

서 민진

Replace Oracle db with Postgres db , add an adapter

I have a source code querying an Oracle database. Is it possible to replace the Oracle database by a PostgreSQL database without modifying the source code ? I thought about adding an adapter/wrapper m...
test-img

clouvis

postgresql

oracle

adapter

postgres-fdw

oracle-fdw

Votes: 0

Answers: 1

Latest Answer

PostgreSQL is strict about ISO SQL standard implementation. Most recent Oracle versions are also compliant. Oracle usually implemented some feature long before it was standardized therefor their diale...
test-img

ibre5041

Strange query by oracle_fdw

I am using oracle_fdw 2.2.0devel, PostgreSQL 10.13, Oracle client 18.3.0.0.0 We have a foreign table in Postgres defined as this: CREATE FOREIGN TABLE public.tickers ( ticker_id INTEGER, ...
test-img

Landon Statis

postgresql

oracle-fdw

Votes: 0

Answers: 1

Latest Answer

The only way that oracle_fdw will generate an Oracle query that uses the upper function is if the original PostgreSQL query already had upper in it.
test-img

Laurenz Albe

Posts

Questions

Blogs

Jobs