Am Sun, 17 Feb 2008 09:17:08 -0500
schrieb Tom Lane <tgl@sss.pgh.pa.us>:
> 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
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:
INFO: string-size : 48015
INFO: +++++++++++++++++++++++++++
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
The surprising thing is that the data can be displayed using elog but
not returend with a string pointer.
Is there any good example which I could read?
Best Regards,
Stefan