Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199407012146.OAA02837@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Fri, 1 Jul 1994 14:46:31 -0700
From: "Andrew K. Yu" <andrew@postgres.Berkeley.EDU>
Message-Id: <199407012146.OAA21057@eden.CS.Berkeley.EDU>
To: aataneja@cs.mtu.edu
Subject: Re:  size of string in APPEND
Cc: postgres@postgres.Berkeley.EDU
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Fri, 01 Jul 94 14:46:30 -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
backend.
	
> Where (& what ) do I have to hack to get over this problem ..??

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

-andrew

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