sql-info.de
May 31, 2019

Firebird Foreign Data Wrapper (FDW) | firebird_fdw 1.1.0 released

firebird_fdw is now available as version 1.1.0.

This release provides following new features:

  • support for PostgreSQL 12 (tested against PostgreSQL 12beta1)
  • following utility functions:
    • firebird_fdw_close_connections()
    • firebird_fdw_diag()

This release requires Firebird API wrapper libfq version 0.4.0 or later.

It is compatible with PostgreSQL versions 9.2 ~ 11, and PostgreSQL 12beta1.

CentOS rpm packages are available via the Fedora Copr build system.

Posted at 10:15 AM
Comments
Hi,

I managed to move further a little bit by setting the following variables:

export PG_CPPFLAGS="-I/Library/Frameworks/Firebird.framework/Versions/A/Headers/ -I/usr/local/include"
export SHLIB_LINK="-L/Library/Frameworks/Firebird.framework/Versions/A/Libraries/ -L/usr/local/lib”

After that, the make install process stops at:

gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -g -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.9.sdk -mmacosx-version-min=10.9 -arch x86_64 -O2 -bundle -multiply_defined suppress -o firebird_fdw.so src/connection.o src/convert.o src/firebird_fdw.o src/options.o -L/Library/PostgreSQL/12/lib -L/opt/local/Current/lib -L/opt/local/libexec/llvm-6.0/lib -L/opt/local/libexec/llvm-6.0/lib -L/opt/local/20180529/lib -Wl,-flat_namespace -L/Library/Frameworks/Firebird.framework/Versions/A/Libraries/ -L/usr/local/lib -lfq -lfbclient -bundle_loader /Library/PostgreSQL/12/bin/postgres
ld: warning: directory not found for option '-L/opt/local/Current/lib'
ld: warning: directory not found for option '-L/opt/local/libexec/llvm-6.0/lib'
ld: warning: directory not found for option '-L/opt/local/libexec/llvm-6.0/lib'
ld: warning: directory not found for option '-L/opt/local/20180529/lib'
ld: warning: ignoring file /Library/Frameworks/Firebird.framework/Versions/A/Libraries//libfbclient.dylib, building for macOS-x86_64 but attempting to link with file built for macOS-i386
/opt/local/bin/clang-mp-6.0 -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2 -I/Library/Frameworks/Firebird.framework/Versions/A/Headers/ -I/usr/local/include -I. -I./ -I/Library/PostgreSQL/12/include/postgresql/server -I/Library/PostgreSQL/12/include/postgresql/internal -I/opt/local/Current/include -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.9.sdk -I/opt/local/20180529/include/libxml2 -I/opt/local/Current/include/libxml2 -I/opt/local/Current/include -flto=thin -emit-llvm -c -o src/connection.bc src/connection.c
make: /opt/local/bin/clang-mp-6.0: No such file or directory
make: *** [src/connection.bc] Error 1

Could you give me some pointer for this?

Thanks.
Posted by: KC | 2019-12-24 05:50
> make: /opt/local/bin/clang-mp-6.0: No such file or directory

Have you tried installing llvm/clang?
Posted by: Ian Barwick | 2020-01-02 00:36
After installing llvm/clang using brew install llvm, now the error becomes:

USE_PGXS=1 make install

/opt/local/bin/clang-mp-6.0 -Wno-ignored-attributes -fno-strict-aliasing -fwrapv -O2 -I. -I./ -I/Library/PostgreSQL/12/include/postgresql/server -I/Library/PostgreSQL/12/include/postgresql/internal -I/opt/local/Current/include -isysroot /Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.9.sdk -I/opt/local/20180529/include/libxml2 -I/opt/local/Current/include/libxml2 -I/opt/local/Current/include -flto=thin -emit-llvm -c -o src/connection.bc src/connection.c
make: /opt/local/bin/clang-mp-6.0: No such file or directory
make: *** [src/connection.bc] Error 1

Could you give me some pointer for this?

Thanks.
Posted by: KC | 2020-01-07 06:07