From: Rob Tester <robtester@gmail.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
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 14:23:41 -0700
Message-ID: <07ed01c7966e$308ffc20$91aff460$@com> (raw)
In-Reply-To: <29473.1179176436@sss.pgh.pa.us>
References: <f5f60fb50705120826q7e08c426offc9268bb776e8b6@mail.gmail.com>
<20070513181154.GB11750@alvh.no-ip.org>
<07ec01c79669$25dad7a0$719086e0$@com>
<29473.1179176436@sss.pgh.pa.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
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: robtester@gmail.com, tgl@sss.pgh.pa.us, alvherre@commandprompt.com
Subject: Re: Trouble returning a text field from an SRF
In-Reply-To: <07ed01c7966e$308ffc20$91aff460$@com>
* 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