From: | Stefan Niantschur <sniantschur(at)web(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to return a large String with C |
Date: | 2008-02-17 17:13:29 |
Message-ID: | 20080217181329.6b0fa26d@trabant.niantschur.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Am Sun, 17 Feb 2008 09:17:08 -0500
schrieb Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Stefan Niantschur <sniantschur(at)web(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Vyacheslav Kalinin | 2008-02-17 17:23:40 | Re: How to return a large String with C |
Previous Message | Colin Wetherbee | 2008-02-17 14:51:27 | Re: How to return a large String with C |