Re: tds_fdw binary column

2018-10-10 Thread Adrian Klaver
On 10/10/18 12:20 PM, Aleš Zelený wrote: Hello, thanks for the testcase! Test cases with added msg_handler test_get_some_id) Thanks to chosen small table, it fast enough: =# select branch_id from ase.tds_tbl where branch_id::text = '\x00038500875c3d60'; NOTICE:  DB-Library notice: Msg #: 5

Re: tds_fdw binary column

2018-10-10 Thread Aleš Zelený
Hello, thanks for the testcase! First of all, some more environment information: Foreign server: [local]:5432 postgres@postgres:13713 =# \des+ ase List of foreign servers ┌───┬──┬──┬──┬─┬

Re: tds_fdw binary column

2018-10-10 Thread Adrian Klaver
On 10/10/18 1:31 AM, Aleš Zelený wrote: Hello, my fault, I've forgot to mention that I have only DSN and database user/password credentials with no access to the box with Sybase. trying to reach service vendor support,  but it might take some time and I hoped I've done some mistake on my side

Re: tds_fdw binary column

2018-10-10 Thread Aleš Zelený
Hello, my fault, I've forgot to mention that I have only DSN and database user/password credentials with no access to the box with Sybase. trying to reach service vendor support, but it might take some time and I hoped I've done some mistake on my side... Kind Regards Ales Zeleny st 10. 10. 201

Re: tds_fdw binary column

2018-10-09 Thread Adrian Klaver
On 10/9/18 12:07 PM, Aleš Zelený wrote: Hello, I've an issue with foreign table using tds_fdw from PostgreSQL 10 to Sybase ASE 15.7. The issue is, that primary key, which I have to use for my predicate is in Sybase data type binary. Foreign table maps ID column from Sybase binary to Postgr

tds_fdw binary column

2018-10-09 Thread Aleš Zelený
Hello, I've an issue with foreign table using tds_fdw from PostgreSQL 10 to Sybase ASE 15.7. The issue is, that primary key, which I have to use for my predicate is in Sybase data type binary. Foreign table maps ID column from Sybase binary to PostgreSQL BYTEA. Simple select is smooth: [local]: