Re: Generating Huge String?

Steffen Nielsen <styf@cs.auc.dk> writes:
> I have tried using chunks technique when creating huge string for a stored 
> procedure (C code). I work like charm for small string, but when i create 
> large strings i get a "server closed the connection unexpectedly" :-(

Look for bugs in your code ;-).  I'd bet it's scribbling on memory that
doesn't belong to it.

> And how does one normally handle Large strings in postgres?

The StringInfo functions are moderately convenient in most cases.
        regards, tom lane