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@aklaver.com <mailto:adrian.klaver@aklaver.com>> 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@aklaver.com <mailto:adrian.klaver@aklaver.com>
>>
>>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com