Re: psqlodbc problem Urgent

Hi all,

 We use postgres version 7.5.9-2 with psqlodbc version 7.3-3 that comes
as built in package with RHEL3 for our application.We  found a bug in
psqlodbc. When we  try to execute a query while the postgres database is
down or  crashed (Note: This condition occurs after calling SQLConnect
once to  connect to postgres & several calls to executeQuery) the
SQLExecute crashes displaying Broken pipe.

Note: But i did not find this in earlier version of psqlodbc.

The Code goes like this I call this function executeQuery multiple
times  with pause in between. Between two calls to executeQuery, the
postgres crashes and the very first call to executeQuery after that
causes the program to crash as mentioned above.

 ##################################
 Void executeQuery()
 {
        int i, iRetValue;

         iRetValue = SQLPrepare( hstmt, (UCHAR *) cmds[i], SQL_NTS );

         if ( iRetValue != SQL_SUCCESS )
         {
             printf( "SQLError SQLPrepare() failed\n" );
             return;
         }

         //printf("Executing: %s\n", cmds[i]);
         iRetValue = SQLExecute ( hstmt );
         if ( iRetValue != SQL_SUCCESS )
         {
             printf( "SQLError SQLExecute() failed with retVal: %d\n",
 iRetValue
         }
 );

 Is their any way to verify postgres connection. If so please help me.


                                                           with regards
                             raja