Hi again!
I'm stuck again, now with the extension itself. I've tried like
everything I could think of filling the fields in
the example on [1]. My database is named "testdb", my table "testtable"
and the (default) schema is
(I believe) "dbo". Does anybody know the values I need to enter in the
CREATE FOREIGN TABLE command?
The odbc-connection (named "odbc-test") works fine. The database server
is a Microsoft SQL Server 2008 R2.
Sadly, if the extension can't execute the query, it just says "Opps".
This isn't very helpful. Should I contact the
author directly?
Thanks again for your help.
Flo
References:
[1] https://github.com/ZhengYang/odbc_fdw
Am 30.11.2011 12:01, schrieb Albe Laurenz:
Florian Schwendener wrote:
[has problems building odbc_fdw]
Oh, didn't see that! Now it says:
root@ubuntu:/home/user/Downloads/odbc_fdw-0.1.0#
PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1
make: Nothing to be done for `all'.
I remember trying a few options with the make command. Is it maybe
already built?
Looks like it.
You can
PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 clean
to delete already built files.
Then you can rebuild.
After building, use
PATH=/usr/local/pgsql/bin/:$PATH make USE_PGXS=1 install
to install.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
