From: | Yuichi Tanaka <yuichi_tanaka(at)cybozu(dot)co(dot)jp> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Unable to open large object. |
Date: | 2009-02-27 06:47:20 |
Message-ID: | 0_81104600_1235717240.28409.cbgrn@enoch.corp.cybozu.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> you *must* repeat PQgetResult until you get NULL before
> any other command can be issued on that connection.
Hmm, I understand the behaviour.
Thank you for your reply!
Tom Lane wrote:
> Yuichi Tanaka <yuichi_tanaka(at)cybozu(dot)co(dot)jp> writes:
> > Do I always have to call PQgetResult until this function returns NULL pointer?
>
> Yes. Failing to do that is an erroneous use of PQsendQuery, and it has
> nothing particularly to do with large objects. Once you've done
> PQsendQuery, you *must* repeat PQgetResult until you get NULL before
> any other command can be issued on that connection.
>
> regards, tom lane
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
----
Yuichi Tanaka (yuichi_tanaka(at)cybozu(dot)co(dot)jp)
From | Date | Subject | |
---|---|---|---|
Next Message | vivawasser | 2009-03-01 00:07:53 | sorting and grouping with min/max |
Previous Message | Tom Lane | 2009-02-27 05:58:07 | Re: Unable to open large object. |