Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres server process crashes when using odbc_fdw - Mailing list pgsql-general

From Ravi Krishna
Subject Re: postgres server process crashes when using odbc_fdw
Date
Msg-id 203483C5-DEE0-48D2-A254-6154BF53AFE0@aol.com
Whole thread Raw
In response to Re: postgres server process crashes when using odbc_fdw  (Ravi Krishna <srkrishna1@aol.com>)
Responses Re: postgres server process crashes when using odbc_fdw  (Andres Freund <andres@anarazel.de>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

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