Re: Database link from Postgres to Oracle using ODBC

On 01/06/2014 07:35 AM, Bart Klein Ikink wrote:
> I have included the path, but still having problems. What is wrong here?

> export PATH=$PATH:/root/test/unixODBC-2.3.2/include:/usr/pgsql-9.2/bin
>
> make USE_PGXS=1
> 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
>

Not quite sure but I would say you do not have the Postgres development
files.
Did you install Postgresql 9.2 from source or from a package?
If from a package you will need to install the postgresql-devel package
for 9.2

--
Adrian Klaver
adrian.klaver@gmail.com