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)
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? |