Re: [GENERAL] Oracle_FDW - Cache lookup failed

2014-03-28 Thread Albe Laurenz
Emanuel Araújo wrote: > I have a problem wiht Oracle FDW 0.9.10 in PostgreSQL 9.3 > > I am using pg 9.3.4 > > Oracle FDW 0.9.10 > > Fedora 20 > > Client Oracle Release 11.2.0.3.0 > > > Return Error: > > ERROR: cache lookup failed for type 0 This is a known bug, the fix is already committed

[GENERAL] Oracle_FDW - Cache lookup failed

2014-03-27 Thread Emanuel Araújo
Hi, I have a problem wiht Oracle FDW 0.9.10 in PostgreSQL 9.3 I am using pg 9.3.4 Oracle FDW 0.9.10 Fedora 20 Client Oracle Release 11.2.0.3.0 Return Error: ERROR: cache lookup failed for type 0 I am executing the simple query in most foreign tables.. Example wher tables with f_ are foreign t

Re: [GENERAL] oracle_fdw with oracle os authentication

2012-10-29 Thread Albe Laurenz
[added CC to oracle-fdw-general, where this should be] Papiernik Anna-AAP053 wrote: > I have Oracle with OS authentication. > > And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database. > > > > I have performed steps: > > CREATE EXTENSION oracle_fdw; > >

Re: [GENERAL] oracle_fdw with oracle os authentication

2012-10-24 Thread Xiong He
rnik Anna-AAP053"; Date: Tue, Oct 23, 2012 06:07 PM To: "pgsql-general@postgresql.org"; Subject: [GENERAL] oracle_fdw with oracle os authentication I have Oracle with OS authentication. And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQ

[GENERAL] oracle_fdw with oracle os authentication

2012-10-23 Thread Papiernik Anna-AAP053
I have Oracle with OS authentication. And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database. I have performed steps: CREATE EXTENSION oracle_fdw; CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver ''); GRANT USAGE ON FOREIGN SERVER oradb

[GENERAL] oracle_fdw with oracle os authentication

2012-10-23 Thread Papiernik Anna-AAP053
Hi I have Oracle with OS authentication. And I have installed PostgreSQL and I want to migrate data from Oracle to PostgreSQL database. I have performed steps: CREATE EXTENSION oracle_fdw; CREATE SERVER oradb FOREIGN DATA WRAPPER oracle_fdw OPTIONS (dbserver ''); GRANT USAGE ON FOREIGN SERVER or

Re: [GENERAL] oracle_fdw

2012-10-22 Thread Albe Laurenz
Rob wrote: > Some more info > Oracle Server:Oracle 11g R2 (11.2.0.2.0) > Client: 11.2 > Was installed using Oracle Universal Installer Ok. > I don't really want to post the full environment of the postmaster but > basically I could see no entry in there for ORACLE_HOME or TNS_ADMIN, should > I?

Re: [GENERAL] oracle_fdw

2012-10-19 Thread hartrc
Thanks Laurenz for your post... Some more info Oracle Server:Oracle 11g R2 (11.2.0.2.0) Client: 11.2 Was installed using Oracle Universal Installer I don't really want to post the full environment of the postmaster but basically I could see no entry in there for ORACLE_HOME or TNS_ADMIN, should

Re: [GENERAL] oracle_fdw

2012-10-19 Thread Albe Laurenz
[I'll CC the oracle_fdw mailing list where this should be.] Rob wrote: > Environment: PostgreSQL 9.1.6 > SLES 11 SP2 > Oracle_fdw 0.9.7 > > I am trying to implement the use of oracle_fdw. > So far I have installed an oracle client on my postgres server. I can > connect to the oracle environment f

[GENERAL] oracle_fdw

2012-10-18 Thread hartrc
Environment: PostgreSQL 9.1.6 SLES 11 SP2 Oracle_fdw 0.9.7 I am trying to implement the use of oracle_fdw. So far I have installed an oracle client on my postgres server. I can connect to the oracle environment from the postgres server (as postgres os user) by navigating to $ORACLE_HOME/bin then