Skip site navigation (1) Skip section navigation (2)

Re: Unable to open large object.

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 (view raw or flat)
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)

In response to

pgsql-novice by date

Next:From: vivawasserDate: 2009-03-01 00:07:53
Subject: sorting and grouping with min/max
Previous:From: Tom LaneDate: 2009-02-27 05:58:07
Subject: Re: Unable to open large object.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group