Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id QAA03819 for postgres-redist; Fri, 1 Jul 1994 16:45:59 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199407012345.QAA03819@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from cs.mtu.edu (cs.mtu.edu [141.219.150.12]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id QAA03803 for <postgres@nobozo.CS.Berkeley.EDU>; Fri, 1 Jul 1994 16:45:52 -0700
Received: from tamarack.mtu.edu (tamarack.cs.mtu.edu) by cs.mtu.edu (4.1/SMI-4.1)
	id AA05202; Fri, 1 Jul 94 19:45:52 EDT
From: aataneja@cs.mtu.edu (Bruce Taneja.)
Message-Id: <9407012345.AA05202@cs.mtu.edu>
Subject: Re:  size of string in APPEND 
To: postgres@postgres.Berkeley.EDU
Date: Fri, 1 Jul 1994 19:45:52 -0400 (EDT)
Cc: andrew@CS.Berkeley.EDU
X-Mailer: ELM [version 2.4 PL22]
Content-Type: text
Content-Length: 1321      
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Fri, 01 Jul 94 16:45:53 -0700
Resent-XMts: smtp

> > The back end crashes when the size of i/p string for
> > a defined ADT is approx > 100   ..
> > i.e APPEND ntable (a="some_string_>_100_char_long"::ADT) \g
> 
> > causes some problems causing backend to "not respond" ..
> 	
> this is just postgres' friendly way of informing you the untimely death of
> the backend.
> 
> > I believe the input string (char*) in postgres is posssibly
> > m(p)alloced  to = 100 (or some thing like that ) ..
> 
> no, the query buffer is 8KB. Besides, you'll get a message from the parser
> (probably telling you about an unterminated string) instead of crashing the

Can you CONFIRM the 8KB buffer for postgres version 4.1 ??

> backend.
> I suspect the bug is in your ADT input function. Look at it again.
> 


The reason I suspect postgres is because I have another copy of my

which works like a piece of cake .. for all my various sized input
strings, .. 
however the monitor will APPEND only strings of size <100 , and
starts giving trouble in susequent (not the long stringed append!) appends
and .. once the backend does "not respond", then monitor hangs, ..

Even on exiting from monitor with a ^C and restarting up monitor
(even tried killing postmaster & restarting it), and running
ANY other command (on that particular data base) will cause monitor
to hang ..

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