Skip site navigation (1) Skip section navigation (2)

Re: PQisBusy() always busy

From: bradg <bg4all(at)me(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: PQisBusy() always busy
Date: 2011-09-12 17:21:08
Message-ID: 1315848068901-4794992.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks Merlin.

I added the piece to check PQconsumeInput(). Unfortunately it has not solved
my problem. It returns 1 indicating "no error" and PQisBusy() still returns
1 indefinitely.

Here's the updated code:


bool is_result_ready( PGconn * connection )
{
    int                 my_socket;
    struct timeval      timer;
    fd_set              read_mask;
    
    if( PQisBusy( connection ) == FALSE )
        return( TRUE );
    
    my_socket = PQsocket( connection );
    
    timer.tv_sec  = (time_t)1;
    timer.tv_usec = 0;
    
    FD_ZERO( &read_mask );
    FD_SET( my_socket, &read_mask );
    
    if( select( my_socket + 1, &read_mask, NULL, NULL, &timer ) == 0 )
    {
        return( FALSE );
    }
    else if( FD_ISSET( my_socket, &read_mask ))
    {
        if (PQconsumeInput( connection ))
        {
            if( PQisBusy( connection ))
                return( FALSE );
            else
                return( TRUE );
        }
        else
        {
            printf("ERROR with PQconsumeInput(): %s\n",
PQerrorMessage(connection));
            return ( FALSE );
        }
    }
    else
    {
        return( FALSE );
    }
}

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PQisBusy-always-busy-tp4793847p4794992.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Responses

pgsql-novice by date

Next:From: Merlin MoncureDate: 2011-09-12 18:39:35
Subject: Re: PQisBusy() always busy
Previous:From: Merlin MoncureDate: 2011-09-12 14:16:51
Subject: Re: PQisBusy() always busy

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group