DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:from:to:cc:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language;
	b=IyE3UtjCRJYiKurajG/s0VyQ9TmNI9w+c43nssxtqm3CzY0eGS3POsZtMAw5ySG0yti5bpSAjPlWqr92JPqHcQfj5EX0P0Srk3/CC+YWQ34xRvEeQJrlTxtGCuHk4B3YJOLsGhzOIUXxFso6aiUjpVu22Jcm1WZTglZsZtLyBDo=
From: "Rob Tester" <robtester@gmail.com>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: "'Alvaro Herrera'" <alvherre@commandprompt.com>,
	<pgsql-interfaces@postgresql.org>
References: <f5f60fb50705120826q7e08c426offc9268bb776e8b6@mail.gmail.com>
	<20070513181154.GB11750@alvh.no-ip.org>
	<07ec01c79669$25dad7a0$719086e0$@com>
	<29473.1179176436@sss.pgh.pa.us>
In-Reply-To: <29473.1179176436@sss.pgh.pa.us>
Subject: Re: Trouble returning a text field from an SRF 
Date: Mon, 14 May 2007 14:23:41 -0700
Message-ID: <07ed01c7966e$308ffc20$91aff460$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
thread-index: AceWavoZLboCanNNT2eq1YAOWEdVSAAAb1uQ
Content-Language: en-us

Hmm..

wktStr was the original variable name from the code, I changed it to be more
'readable' for the question I was presenting (probably not a good idea in
hindsight). The length calculation has been changed as well and what I
presented would be a few bytes short. 

I have tried this using pgadmin3 (v1.6.1) and npgsql with the same results,
no data returned in the text field when the data goes over 65535 chars.
Maybe both clients are incorrectly setting a limit on a text field?


Rob.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
Sent: Monday, May 14, 2007 2:01 PM
To: Rob Tester
Cc: 'Alvaro Herrera'; pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Trouble returning a text field from an SRF 

"Rob Tester" <robtester@gmail.com> writes:
> I created my tuple that way and set the Datum using
> DirectFunctionCall1(...), but there still seems to be a limitation at
65535
> chars for the data. When my string is 65535 (or shorter) I get the text
> back. When it is longer I get nothing for the string, but the rest of the
> tuple is intact.

Maybe the problem is on the client side?  There's no visible restriction
in the code you quoted (though I am wondering a bit about what "wktStr"
is, and whether you've computed the required size of textOut correctly).

			regards, tom lane