Re: libpq sendQuery -- getResult not returning until all queries complete

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: libpq sendQuery -- getResult not returning until all queries complete
Date: 2010-12-21 20:07:46
Message-ID: c35ef788-7427-44b6-bbc0-cc09f25300fd@mm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kelly Burkhart wrote:

> #define COMMANDS "select current_timestamp; select pg_sleep(5); select
> current_timestamp"

You should use current_clock() instead of current_timestamp, because
current_timestamp returns a fixed value throughout a transaction.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-12-21 20:14:22 Re: libpq sendQuery -- getResult not returning until all queries complete
Previous Message Kelly Burkhart 2010-12-21 19:53:10 Re: libpq sendQuery -- getResult not returning until all queries complete