Re: postgres server process crashes when using odbc_fdw

From: Andres Freund <andres(at)anarazel(dot)de>
To: Ravi Krishna <srkrishna1(at)aol(dot)com>
Cc: "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 17:02:42
Message-ID: 20181017170242.l7vqebtcocuhqi5v@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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","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.

Please note that odbc_fdw is not maintained by the postgresql
developers, but a separate project.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2018-10-17 17:57:37 Re: postgres server process crashes when using odbc_fdw
Previous Message Ravi Krishna 2018-10-17 15:17:11 Re: postgres server process crashes when using odbc_fdw