Re: Database link from Postgres to Oracle using ODBC

On 01/09/2014 02:31 AM, Bart Klein Ikink wrote:
> 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
>
>

See if this works.

In the ODBC-Link-1.0.4 directory open odbclink.c
and at the top of the file under the other #includes add:

#include "utils/timestamp.h"

If that does not work then I would suggest contacting the authors of
ODBC-Link and see if they have any suggestions.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com