From: "Rodrigo Moreno" <rodrigo.miguel@terra.com.br>
To: <pgsql-interfaces@postgresql.org>
Subject: How to use PQconsumeInput and PQisBusy correctly ?
Date: Sun, 13 Mar 2005 12:56:32 -0300
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AcUn5TndHQNU5+/MSwSVWvDwdfecng==
Message-Id: <20050313155643.687B23C00B@talara.terra.com.br>

Hi all,

What's the right way to use pqconsumeinput and pqisbusy ?

The below code could be used to do that ? 

Thanks a Lot
Rodrigo Moreno


PS: Please don't worry if some code is wrong, I do not test this code yeat.


void query(PGconn *conn, const char *stmt)
{
    PGresult    *res;
    int         nFields;
    int         i,j;
    int         send;

    send = PQsendQuery(conn, stmt);
    
    if (PQconsumeInput(conn))
    {
        while (PQisBusy(conn))
        {
            printf(".");
            sleep(500);
            PQconsumeInput(conn);
        }
        
        res = PQgetResult(conn);            
            
        if (PQresultStatus(res) != PGRES_TUPLES_OK)
        {
            fprintf(stderr, "failed: %s", PQerrorMessage(conn));
            PQclear(res);
            exit_nicely(conn);
        }
        
        nFields = PQnfields(res);
        
        for (i = 0; i < nFields; i++)
            printf("%-15s", PQfname(res, i));
                
        printf("\n\n");
        
        for (i = 0; i < PQntuples(res); i++)
        {
            for (j = 0; j < nFields; j++)
                printf("%-15s", PQgetvalue(res, i, j));
                
            printf("\n");
        }
        
        PQclear(res);
    }        
}