Re: This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function. - Mailing list pgsql-odbc

From rohtodeveloper
Subject Re: This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function.
Date
Msg-id BAY178-W42F12DB78E7FD290B68B9EC49F0@phx.gbl
Whole thread Raw
In response to Re: This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function.  (rohtodeveloper <rohtodeveloper@outlook.com>)
Responses Re: This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function.  ("Inoue, Hiroshi" <inoue@tpf.co.jp>)
List pgsql-odbc
I'm so sorry, it seems that there was something wrong with the pictures in my last letter.
Here I send the mail again with the correct pictures:
 

Thanks a lot for your answer.

 

Well ,in fact, if I use the extension called odbc_fdw , the same problem will happen.

That’s because the odbc_fdw will also call the odbc driver.

The follow pictures explain the situation.

 

 

When use the odbc_fdw extension, the libraries are loaded in the following way.

 
 

 

After all the libraries are loaded, When the function check_client_encoding is called , the whole postgres process will crash , result in a core dumped problem.

 
 
 
 
Best Regards,
rohtodeveloper
 

From: rohtodeveloper@outlook.com
To: michael.paquier@gmail.com
CC: pgsql-odbc@postgresql.org
Subject: RE: [ODBC] This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function.
Date: Tue, 28 Oct 2014 17:35:48 +0000

Thanks a lot for your answer.

 

Well ,in fact, if I use the extension called odbc_fdw , the same problem will happen.

That’s because the odbc_fdw will also call the odbc driver.

The follow pictures explain the situation.

 

 

When use the odbc_fdw extension, the libraries are loaded in the following way.


 

After all the libraries are loaded, When the function check_client_encoding is called , the whole postgres process will crash , result in a core dumped problem.

image003.png@01CFF29B.73455510

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                                                                                                                                       Best Regards,
                                                       rohtodeveloper
 

Date: Mon, 20 Oct 2014 21:06:24 +0900
Subject: Re: [ODBC] This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function.
From: michael.paquier@gmail.com
To: rohtodeveloper@outlook.com
CC: pgsql-odbc@postgresql.org



On Mon, Oct 20, 2014 at 8:56 PM, rohtodeveloper <rohtodeveloper@outlook.com> wrote:
If I create a postgres's FUNCTION(myfunc()) using C languageand use this FUNCTION to call the odbc driver(psqlodbcw.so),this problem may happen.
Why would you want to do that? ODBC driver should run as a client process and should not need to interact in any way with a Postgres server process, aka an internal session of the instance.
--
Michael
Attachment

pgsql-odbc by date:

Previous
From: rohtodeveloper
Date:
Subject: Re: This may be a bug: odbc's function"check_client_encoding" have the same name with postgres's function.
Next
From: "blakeduffey ."
Date:
Subject: pgsql-odbc and client certs