Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <rhart2@mt.gov>) id 1TPD13-0007TR-BC
	for pgsql-general@postgresql.org; Fri, 19 Oct 2012 13:53:33 +0000
Received: from sam.nabble.com ([216.139.236.26])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <rhart2@mt.gov>) id 1TPD0y-0006fP-2G
	for pgsql-general@postgresql.org; Fri, 19 Oct 2012 13:53:32 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <rhart2@mt.gov>) id 1TPD0w-0006hG-Gd
	for pgsql-general@postgresql.org; Fri, 19 Oct 2012 06:53:26 -0700
Date: Fri, 19 Oct 2012 06:53:26 -0700 (PDT)
From: hartrc <rhart2@mt.gov>
To: pgsql-general@postgresql.org
Message-ID: <1350654806509-5729005.post@n5.nabble.com>
In-Reply-To: 
 <D960CB61B694CF459DCFB4B0128514C208902B3D@exadv11.host.magwien.gv.at>
References: <1350593603292-5728931.post@n5.nabble.com>
	<D960CB61B694CF459DCFB4B0128514C208902B3D@exadv11.host.magwien.gv.at>
Subject: Re: oracle_fdw
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.8 (/)
X-Archive-Number: 201210/599
X-Sequence-Number: 191567

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
I?

LD_LIBRARY_PATH=mypostgreshomedirectory/lib

are there any others in particular of interest?

Here is my fdw, server and foreign table specs. I have 'myinstancename'
defined in tnsnames.ora which is in $ORACLE_HOME/NETWORK/ADMIN


CREATE FOREIGN DATA WRAPPER oracle_fdw
  HANDLER oracle_fdw_handler
  VALIDATOR oracle_fdw_validator;
ALTER FOREIGN DATA WRAPPER oracle_fdw
  OWNER TO postgres;

CREATE SERVER myinstancename
   FOREIGN DATA WRAPPER oracle_fdw
  OPTIONS (dbserver 'myinstancename');
ALTER SERVER myinstancename
  OWNER TO postgres;


CREATE FOREIGN TABLE public.wild_lek
   ("WL_ID" integer ,
    "WL_ALIAS" character varying(50) ,
    "WL_AHM_FL" character varying(1) ,
    "WL_INACTIVE_FL" character varying(1) ,
    "WL_SATELLITE_FL" character varying(20) ,
    "WL_LESPPSG_FL" character varying(1) )
   SERVER myinstancename
   OPTIONS (table 'MYUSER.MYTABLE');
ALTER FOREIGN TABLE 'MYUSER.MYTABLE'  OWNER TO postgres;


Rob



--
View this message in context: http://postgresql.1045698.n5.nabble.com/oracle-fdw-tp5728931p5729005.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.