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

Non-blocking queries using libpq

From: Ewan Mellor <em(at)nexus(dot)co(dot)uk>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Non-blocking queries using libpq
Date: 1998-07-15 09:19:16
Message-ID: 35AC7414.12D680B@nexus.co.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
I am having trouble using libpq to query my database in a non-blocking
manner.  My test program looks like this:

#include <stdio.h>
#include <libpq-fe.h>

main()
{
  PGconn *conn;
  PGresult *res;

  conn = PQsetdb(NULL, NULL, NULL, NULL, "test");

  PQsendQuery(conn, "select * from test_tbl");
  while(PQisBusy(conn))
    ;

  res = PQgetResult(conn);

  printf("%s.\n", PQgetvalue(res, 0, 0));

  PQclear(res);
  PQfinish(conn);

  return 0;
}

First off, is this OK? (Of course, my real program does things whilst
PQisBusy() and checks for errors etc.)

My problem is that PQisBusy() is never returning FALSE because
conn->asyncStatus is always PGASYNC_BUSY.

PQisBusy() looks like this:

int
PQisBusy(PGconn *conn)
{
	if (!conn)
		return FALSE;

	/* Parse any available data, if our state permits. */
	parseInput(conn);

	/* PQgetResult will return immediately in all states except BUSY. */
	return (conn->asyncStatus == PGASYNC_BUSY);
}

It seems to me that the call to parseInput() will never do anything
because there is no way that data will be read from the backend.  Is
that correct?  Is the user application supposed to do that?

I am using a snapshot dated a month or two ago.

Thanks in advance,

Ewan Mellor.

pgsql-interfaces by date

Next:From: Herouth MaozDate: 1998-07-15 09:40:36
Subject: Re: [INTERFACES] libpq & user
Previous:From: Herouth MaozDate: 1998-07-15 08:33:59
Subject: RE: [INTERFACES] What technology ???

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