Received: from ns2.cybervale.com ([207.241.176.10])
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA64566
	for <pgsql-interfaces@postgresql.org>;
	Sun, 5 Dec 1999 15:40:15 -0500 (EST)
	(envelope-from caspanis@cybervale.com)
Received: from cybervale.com (crandle@[207.241.176.134])
	by ns2.cybervale.com (8.9.3/8.9.3) with ESMTP id PAA26381
	for <pgsql-interfaces@postgresql.org>; Sun, 5 Dec 1999 15:51:47 -0500
Sender: crandle@ns2.cybervale.com
Message-ID: <384ACD0B.2491AFBE@cybervale.com>
Date: Sun, 05 Dec 1999 15:37:31 -0500
From: Charles Randle <caspanis@cybervale.com>
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.10 i586)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Problems with postgres V6.5.3  large objects 
Content-Type: multipart/alternative;
	boundary="------------2A1AF2F002F40ADAA5B415CA"


--------------2A1AF2F002F40ADAA5B415CA
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi all,

I'm  relatively new to postgres amd I'm attempting to use  large objects
to store and play-back messages directly from the database . I have a
number of problems/questions/issues :

1) Whenever I try to open more than one large object within my class
(I'm using C++)  The following message appears in the postgres backend
log-file &  the application terminates .

"query: SELECT message_data FROM receptormessages WHERE message_name =
'wait_mess
age_one'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
ERROR:  update_fp_info: cache lookup for function 1 failed
AbortCurrentTransaction
FATAL 1:  Socket command type
proc_exit(0) [#0]"

    Note 1) - Note that the Oids for the  large objects are stored in a
table called 'receptormessages'
              2) - The transaction necessary for the access to the large
objects begins in the constructor of
                      the class and terminates of the object is ever
destroyed (in the destructor).


2) I am thinking of using the libpq++ interface to access the large
objects , However from what I've seen each instance of the class would
create a new connection to the backend , from the same process !
        a) How expensive is this multiple connection option given that
many large objects may be in use
             at any one time  ?
        b) If this option is expensive , is there any way to access many
large objects  and only have
             one connection to the database  with the C++ interface to
these objects ?


Regards,
Charles Randle.





--------------2A1AF2F002F40ADAA5B415CA
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi all,
<p>I'm&nbsp; relatively new to postgres amd I'm attempting to use&nbsp;
large objects to store and play-back messages directly from the database
. I have a number of problems/questions/issues :
<p>1) Whenever I try to open more than one large object within my class
(I'm using C++)&nbsp; The following message appears in the postgres backend
log-file &amp;&nbsp; the application terminates .<font color="#3366FF"></font>
<p><font color="#000000">"query: SELECT message_data FROM receptormessages
WHERE message_name = 'wait_mess</font>
<br><font color="#000000">age_one'</font>
<br><font color="#000000">ProcessQuery</font>
<br><font color="#000000">CommitTransactionCommand</font>
<br><font color="#000000">StartTransactionCommand</font>
<br><font color="#000000">ERROR:&nbsp; update_fp_info: cache lookup for
function 1 failed</font>
<br><font color="#000000">AbortCurrentTransaction</font>
<br><font color="#000000">FATAL 1:&nbsp; Socket command type</font>
<br><font color="#000000">proc_exit(0) [#0]"</font>
<br><font color="#000000">&nbsp;</font>
<br>&nbsp;&nbsp;&nbsp; Note 1) - Note that the Oids for the&nbsp; large
objects are stored in a table called 'receptormessages'
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
2) - The transaction necessary for the access to the large objects begins
in the constructor of
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
the class and terminates of the object is ever destroyed (in the destructor).
<br>&nbsp;
<p>2) I am thinking of using the libpq++&nbsp;interface to access the large
objects , However from what I've seen each instance of the class would
create a new connection to the backend , from the same process !
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a) How expensive is this
multiple connection option given that many large objects may be in use
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
at any one time&nbsp; ?
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b) If this option is expensive
, is there any way to access many large objects&nbsp; and only have
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
one connection to the database&nbsp; with the C++&nbsp;interface to these
objects ?
<br>&nbsp;
<p>Regards,
<br>Charles Randle.
<p>&nbsp;
<br>&nbsp;
<br>&nbsp;</html>

--------------2A1AF2F002F40ADAA5B415CA--