I have RHEL 6. I have now tried something different:
- yum install gcc
- yum install postgresql92-devel-9.2.5
- yum install unixODBC-2.3.0
- yum install unixODBC-devel
Then:
- cd ODBC-Link-1.0.4
- export PATH=$PATH:/usr/pgsql-9.2/bin
- make USE_PGXS=1
But still having:
gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fpic -I. -I. -I/usr/pgsql-9.2/include/server -I/usr/pgsql-9.2/include/internal -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o odbclink.o odbclink.c
odbclink.c: In function âget_dataâ:
odbclink.c:746: error: âtimestamp_inâ undeclared (first use in this function)
odbclink.c:746: error: (Each undeclared identifier is reported only once
odbclink.c:746: error: for each function it appears in.)
odbclink.c:749: error: âtimestamptz_inâ undeclared (first use in this function)
make: *** [odbclink.o] Error 1
> Date: Tue, 7 Jan 2014 07:27:58 -0800
> From: adrian.klaver@gmail.com
> To: bart_klein_ikink@hotmail.com; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Database link from Postgres to Oracle using ODBC
>
> On 01/06/2014 11:50 PM, Bart Klein Ikink wrote:
> > This is what I did:
> > - yum install gcc
> > - yum install postgresql92-devel-9.2.5
> > - extract unixODBC-2.3.2.tar.gz (in /root/test)
> > - extract ODBC-Link-1.0.4.tar.gz (in /root/test)
> > - cd /root/test/unixODBC-2.3.2
> > - ./configure
> > - make
> > - make install
> > - cd ..
> > - cd ODBC-Link-1.0.4
> > - export PATH=$PATH:/root/test/unixODBC-2.3.2/include:/usr/pgsql-9.2/bin
> > - make USE_PGXS=1
> >
>
> I am not sure what is going on. I can compile here. In my case I am
> using my distributions(OpenSUSE 12.2) package versions of unixODBC and
> unixODBC-devel
>
> You might try to do the same. Note it is important that they be the same
> version for the same version of unixODBC. Then you could get rid of the
> export path=..
>
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com