Re: postgres server process crashes when using odbc_fdw

From: Ravi Krishna <srkrishna1(at)aol(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: postgres server process crashes when using odbc_fdw
Date: 2018-10-17 15:17:11
Message-ID: 203483C5-DEE0-48D2-A254-6154BF53AFE0@aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 has to created in upper case within quotes. It is bit of an annoyance.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2018-10-17 17:02:42 Re: postgres server process crashes when using odbc_fdw
Previous Message Олег Самойлов 2018-10-17 12:22:52 Re: BUG: Incorrect working with POSIX locale if database in UTF-8 encoding