Re: How to return a large String with C - Mailing list pgsql-general

From Tom Lane
Subject Re: How to return a large String with C
Date
Msg-id 27047.1203276498@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to return a large String with C  (Stefan Niantschur <sniantschur@web.de>)
Responses Re: How to return a large String with C
Re: How to return a large String with C (solved)
List pgsql-general
Stefan Niantschur <sniantschur@web.de> writes:
> Am Sun, 17 Feb 2008 09:17:08 -0500
> schrieb Tom Lane <tgl@sss.pgh.pa.us>:
>> Hardly surprising when you're printing the string into a fixed-size
>> 8K buffer. The buffer overflow is smashing the stack, in particular
>> the function's return address.

> Yes, I know, but the backend does not allow for a bigger buffer. Trying
> to use a 80K (char[81920])buffer did not work and returns:

So you've got some other bug in code you didn't show us.  It's highly
unlikely that you wouldn't be able to allocate an 80K buffer.  (Whether
that's big enough for your data even yet is a separate question.)

What I was wondering was why you even bothered with the char[] buffer,
when it looked like the actually useful return value was being
accumulated in an expansible StringInfo buffer.

            regards, tom lane


pgsql-general by date:

Previous
From: "Vyacheslav Kalinin"
Date:
Subject: Re: How to return a large String with C
Next
From: Ivan Sergio Borgonovo
Date:
Subject: function or temporary table or what?