agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Bruce Taneja. <aataneja@cs.mtu.edu>
To: andrew@postgres.Berkeley.EDU
Cc: postgres@postgres.Berkeley.EDU
Subject: README.FIRST .. PROBLEM FOUND!!
Date: Sat, 2 Jul 1994 15:04:26 -0400 (EDT)
Message-ID: <9407021904.AA07435@cs.mtu.edu> (raw)
In-Reply-To: <199407020013.RAA21445@eden.CS.Berkeley.EDU>


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.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: aataneja@cs.mtu.edu, andrew@postgres.Berkeley.EDU
  Subject: Re: README.FIRST .. PROBLEM FOUND!!
  In-Reply-To: <9407021904.AA07435@cs.mtu.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox