| 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: | Whole Thread | Raw Message | 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? |