Re: postgres server process crashes when using odbc_fdw

2018-10-18 Thread Laurenz Albe
Ravi Krishna wrote: > On a related note is fdw for Oracle and SQLServer supported by the community ? The PostgreSQL Global Development Group, specifically these mailing lists, will provide support for "core PostgreSQL", that is the source code you can download from www.postgresql.org and binaries

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Andres Freund
On 2018-10-17 11:02:40 -0700, Adrian Klaver wrote: > On 10/17/18 10:57 AM, Ravi Krishna wrote: > > > > > > > > Please note that odbc_fdw is not maintained by the postgresql developers, > > > but a separate project. > > > > > > Translation: You are on your own. We are hoping this will make our

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Adrian Klaver
On 10/17/18 11:12 AM, Ravi Krishna wrote: Come on. We can't realistically support & debug random postgres extending projects, nor do we have control over them. And you're not necessarily on your own, you could report the issue to odbcfdw's authors/github tracker. Or pay a company for support

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Andres Freund
Hi, On 2018-10-17 14:12:01 -0400, Ravi Krishna wrote: > > > > Come on. We can't realistically support & debug random postgres extending > > projects, nor do we have control over them. And you're not necessarily on > > your own, you could report the issue to odbcfdw's authors/github tracker. >

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Ravi Krishna
> > Come on. We can't realistically support & debug random postgres extending > projects, nor do we have control over them. And you're not necessarily on > your own, you could report the issue to odbcfdw's authors/github tracker. Or > pay a company for support. > On a related note is fdw for

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Andres Freund
On October 17, 2018 10:57:37 AM PDT, Ravi Krishna wrote: > >> >> Please note that odbc_fdw is not maintained by the postgresql >developers, but a separate project. > > >Translation: You are on your own. We are hoping this will make our >migration out of DB2 quicker. Oh well. Come on. We can'

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Adrian Klaver
On 10/17/18 10:57 AM, Ravi Krishna wrote: Please note that odbc_fdw is not maintained by the postgresql developers, but a separate project. Translation: You are on your own. We are hoping this will make our migration out of DB2 quicker. Oh well. No it means you need to take this up wi

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Ravi Krishna
> > Please note that odbc_fdw is not maintained by the postgresql developers, but > a separate project. Translation: You are on your own. We are hoping this will make our migration out of DB2 quicker. Oh well.

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Andres Freund
Hi, On 2018-10-17 11:17:11 -0400, Ravi Krishna wrote: > It turned out that enabling ODBC trace was causing PG to crash. Once > disabled it started working, but found another issue. > All object names in DB2 is assumed to be upper case. odbc_fdw sends queries > like this > > > select "fld1","

Re: postgres server process crashes when using odbc_fdw

2018-10-17 Thread Ravi Krishna
It turned out that enabling ODBC trace was causing PG to crash. Once disabled it started working, but found another issue. All object names in DB2 is assumed to be upper case. odbc_fdw sends queries like this select "fld1","fld2" from "schema_name"."table_name". So the foreign table in PG ha

Re: postgres server process crashes when using odbc_fdw

2018-10-16 Thread Ravi Krishna
I enabled ODBC trace . Attached trace log. Had to edit connection details and snipped few repetitive lines as I ran the same sql multiple times Connection Out [DSN=BLUE;UID=*;PWD=***;DATABASE=***;HOST...] [ODBC][4248][1539734369.611042][SQLGetInfo.c][554] Entry:

postgres server process crashes when using odbc_fdw

2018-10-16 Thread Ravi Krishna
Version 10.5 AWS Linux Foreign server: Db2 on Linux 10.5.9 carto_odbc unix_odbc I am able to build odbc_fdw extension, register the extension and also create foreign server. I also created foreign table. When I run a sql 'select * from odbctest' postgres crashes, generate a core file. 2018-10