From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rob Tester <robtester@gmail.com>
Cc: 'Alvaro Herrera' <alvherre@commandprompt.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Trouble returning a text field from an SRF
Date: Mon, 14 May 2007 17:00:36 -0400
Message-ID: <29473.1179176436@sss.pgh.pa.us> (raw)
In-Reply-To: <07ec01c79669$25dad7a0$719086e0$@com>
References: <f5f60fb50705120826q7e08c426offc9268bb776e8b6@mail.gmail.com>
<20070513181154.GB11750@alvh.no-ip.org>
<07ec01c79669$25dad7a0$719086e0$@com>
"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
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: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, robtester@gmail.com, alvherre@commandprompt.com
Subject: Re: Trouble returning a text field from an SRF
In-Reply-To: <29473.1179176436@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox