Unable to open large object.

From: Yuichi Tanaka <yuichi_tanaka(at)cybozu(dot)co(dot)jp>
To: pgsql-novice(at)postgresql(dot)org
Subject: Unable to open large object.
Date: 2009-02-27 00:42:37
Message-ID: 0_58750200_1235695357.31027.cbgrn@enoch.corp.cybozu.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi, all.
Sorry if you have received same mail in pgsql-bugs mailing list.

I wrote C code with libpq using PQsendQuery and lo_open.
In some situation, I cannot open large object.

The situation is following:
1. Open some large object file (using lo_open).
-> succeed
2. Send query asynchronously (using PQsendQuery).
-> succeed
3. Get query result (using PQgetResult).
-> succeed
4. Open another large object file (using pg_lo_open).
-> fail

As a result, second large object lo_open (No.4) returns false.

But if I execute PQgetResult twice, I can open both large objects.
1. Open some large object file (using lo_open).
-> succeed.
2. Send query asynchronously (using PQsendQuery).
-> succeed.
3. Get query result (using PQgetResult).
-> succeed.
4. Get query result (using PQgetResult).
-> Returns NULL.
5. Open another large object file (using pg_lo_open).
-> succeed.

Do I always have to call PQgetResult until this function returns NULL pointer?

----
Yuichi Tanaka (yuichi_tanaka(at)cybozu(dot)co(dot)jp)

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2009-02-27 05:58:07 Re: Unable to open large object.
Previous Message Tom Lane 2009-02-26 19:56:50 Re: pl/pgsql short circuit evaluation?