On 04/09/2018 04:52 PM, Adrian Klaver wrote:
On 04/09/2018 02:37 PM, karthik kumar wrote:
On Mon, Apr 9, 2018 at 5:13 PM, Adrian Klaver
<adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
On 04/09/2018 02:10 PM, karthik kumar wrote:
Assuming using this:
https://github.com/ZhengYang/odbc_fdw
I believe that should be username and password per above link:
"CREATE USER MAPPING FOR postgres
SERVER odbc_server
OPTIONS (username 'root', password '');
"
Yes.
Does 'yes' mean you changed this:
CREATE USER MAPPING FOR pg SERVER odbc_db2 OPTIONS (odbc_UID
'db2inst1', odbc_PWD 'db2inst1');
to this?:
CREATE USER MAPPING FOR pg SERVER odbc_db2 OPTIONS (username
'db2inst1', password 'db2inst1');
If i try to use username it throws error as invalid option
postgres=# CREATE SERVER driver_db5 FOREIGN DATA WRAPPER odbc_fdw
OPTIONS (dsn 'sample');
CREATE SERVER
postgres=# CREATE USER MAPPING FOR pg SERVER driver_db5 OPTIONS
(username 'db2inst1', password 'db2inst1');
ERROR: invalid option "username"
HINT: Valid options in this context are: <none>
You are using the extension from below, correct?:
Answering my own question after reading the subject line I realize now
you are using:
https://github.com/CartoDB/odbc_fdw
Am not seeing anything wrong at this time.
Did see this issue:
Support PostreSQL 10
https://github.com/CartoDB/odbc_fdw/issues/60
Are you using the latest version of the extension?
https://github.com/ZhengYang/odbc_fdw
In psql what does the below show?:
\dx
What happens if you do not include the OPTIONS?
postgres=# CREATE USER MAPPING FOR pg SERVER driver_db5 OPTIONS
(odbc_UID 'db2inst1', odbc_PWD 'db2inst1');
CREATE USER MAPPING
Thanks,
Karthik.
-- Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
