Re: Trouble returning a text field from an SRF

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rob Tester" <robtester(at)gmail(dot)com>
Cc: "'Alvaro Herrera'" <alvherre(at)commandprompt(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Trouble returning a text field from an SRF
Date: 2007-05-14 21:00:36
Message-ID: 29473.1179176436@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

"Rob Tester" <robtester(at)gmail(dot)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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Rob Tester 2007-05-14 21:23:41 Re: Trouble returning a text field from an SRF
Previous Message Rob Tester 2007-05-14 20:47:52 Re: Trouble returning a text field from an SRF