Обсуждение: PostgreSQL crash at SQLColAttribute()

On 10/15/2014 10:01 PM, Bala krishna Devasani wrote:
> Description: i am using postgresql database as a backend,connecting to
> postgres with *unixodbc driver manager and libodbc++ library and
> psqlodbc driver*. when i try to run my application to query some data it
> is getting crashed. It is getting crashed at random functions.
>
> i cannot exactly trace which function it is crashing.
>
> it is crashing at three functions like
> **
>
> 1.  SQLColAttribute
> 2.  SQLGetInfo
>
>
>
> PostgreSQL version number you are running:
>
> How you installed PostgreSQL:PostgreSQL 9.1 linux ubuntu
>
> Changes made to the settings in the postgresql.conf file: No
>
> Operating system and version:linux ubuntu 12.04 (64-bit)
>
> What program you're using to connect to PostgreSQL:libodbc++-0.2.3
> (libodbc++) library
>
> PostgreSQL odbc driver : psqlodbc version(3.03)
>
> ODBC using:unixODBC-2.3.2
> <ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.2.tar.gz>
>
>
> For questions about any kind of error:
>
> Description : i am trying to connect  my application to PostgreSQL.
> while i am trying run select query's it is getting crashed at certain
> functions.
>
> i am using linux ubuntu (12.04) with unixODBC (2.3.2), PostgreSQL
> database (9.1), psqlodbc driver (3.03) , libodbc++-0.2.3

So, are there any error messages available?
>
>
> Thanks & Regards
> Balakrishna


--
Adrian Klaver
adrian.klaver@aklaver.com

On 10/17/2014 12:22 AM, Bala krishna Devasani wrote:
> No error message were getting . My application is simply getting crashed
> at function SQLGetInfo().
>
> i am using linux ubuntu (12.04)
>
> PostgreSQL:PostgreSQL 9.1
> unixODBC (2.3.2),
> PostgreSQL
> database (9.1),
> psqlodbc driver (3.03) ,
> libodbc++-0.2.3
>
>
> Can u please tell me what might be the problem. is it a problem with
> *postgresql odbc driver* (or) *unix odbc driver* ???

Do not have a clue and without more information I doubt it is solvable.

So:

1) What application are using?

2) What are you doing when you use SQLGetInfo()?
     The code that you are using would be helpful.

3) You mentioned something about a trace. Is there information available
from that trace?

4) If not can you set up a trace?

5) Have you set up logging in ODBC?
    If so what is in the logs?
    If not set it up and then run the code.

>
> Thanks & Regards
> Balakrishna
>


--
Adrian Klaver
adrian.klaver@aklaver.com