Re: Unable to open large object. - Mailing list pgsql-novice

From Yuichi Tanaka
Subject Re: Unable to open large object.
Date
Msg-id 0_81104600_1235717240.28409.cbgrn@enoch.corp.cybozu.co.jp
Whole thread Raw
In response to Unable to open large object.  (Yuichi Tanaka <yuichi_tanaka@cybozu.co.jp>)
List 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@cybozu.co.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice

----
Yuichi Tanaka (yuichi_tanaka@cybozu.co.jp)

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unable to open large object.
Next
From: vivawasser
Date:
Subject: sorting and grouping with min/max