Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199407021904.MAA06802@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: aataneja@cs.mtu.edu (Bruce Taneja.)
Message-Id: <9407021904.AA07435@cs.mtu.edu>
Subject: README.FIRST .. PROBLEM FOUND!!
To: andrew@postgres.Berkeley.EDU
Date: Sat, 2 Jul 1994 15:04:26 -0400 (EDT)
Cc: postgres@postgres.Berkeley.EDU
In-Reply-To: <199407020013.RAA21445@eden.CS.Berkeley.EDU> from "Andrew K. Yu" at Jul 1, 94 05:13:21 pm
Content-Type: text
Content-Length: 1843      
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Sat, 02 Jul 94 12:04:27 -0700
Resent-XMts: smtp


Hi,
About my last email concerning postgres not being able to accept 
strings of > 100 chars ................


OK, I think I got a more narrow view on the problem ::

It has either some thing to do with the system buffer or with 
postgres buffer ..

OBSERVATION 1:

----------------------------
tamarack%  monitor ndb

... /* did a lot of appends */

* append ntable(emp="(2,JF,((k1,1,(c1,c2)),(k2,2,(c3,c4)),(k3,3,(c5,c6,c7))),(),
())"::emp_DT) \g

Query sent to backend is "append ntable(emp="(2,JF,((k1,1,(c1,c2)),(k2,2,(c3,c4)
),(k3,3,(c5,c6,c7))),(),())"::emp_DT) "
Error: No response from the backend, exiting...

tamarack% !!
monitor ndb
Welcome to the C POSTGRES terminal monitor

Go
* append ntable(emp="(2,JF,((k1,1,(c1,c2)),(k2,2,(c3,c4)),(k3,3,(c5,c6,c7))),(),
())"::emp_DT) \g

Query sent to backend is "append ntable(emp="(2,JF,((k1,1,(c1,c2)),(k2,2,(c3,c4)
),(k3,3,(c5,c6,c7))),(),())"::emp_DT) "
APPEND 155776
Go
++++++++++++++++++++++++++++++++++++++++


So even though postgres threw me out on my last append, it happily
accepted the same append right away on restarting the monitor .. 


++++++++++++++++++++++++++++++++++

OBSERVATION 2:

On a really long append , the monitor (or is it the system) accepts slightly
over a 100 chars and then stops accepting the input .. & starts beeping at
you on any key stroke .. 

this happending on a number of occassions when I tried to input the string

* append ntable (emp="(2343,Kids Lover,((kid1 Lover,1,(c1,c2,c3)),(kid2 Lover,5,()),(kid3 Lover,7,(segaVideo,MegaVideo,C++)),(kid4 Lover,6,(c4,c5)),(kid5 Lover,15,(C,Math,Phy,Geomech.,Bio))),((C++,56),(Pascal,6),(LaTeX,7),(Cobol,5)),(345-4344,23LOVER,234532234))"::emp_DT) \g

I was unable to even enter the whole string !

-----------------------------------------------------

Can you see whats going on ??

thanks ..
Bruce

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================