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 10383.1203257828@sss.pgh.pa.us
Whole thread Raw
In response to 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
List pgsql-general
Stefan Niantschur <sniantschur@web.de> writes:
> So far I have been successfully doing calls to SPI, select the data from the
> table and return it. However, this works only with string not larger than
> page size of char[8192].
> The strings I expect are much longer and this causes the backend to crash.

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.

            regards, tom lane

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: the feasibility of sending email from stored procedure in Postgres
Next
From: Colin Wetherbee
Date:
Subject: Re: How to return a large String with C