Re: literal limits in 8.3

On Mon, Nov 24, 2008 at 09:06:14AM -0500, Tom Lane wrote:
> Sam Mason <sam@samason.me.uk> writes:
> > However, I've just tried today and am getting some strange results.  The
> > strange results are that above a certain length PG says that it's put a
> > string in OK but there's nothing there when I look back afterward.
>
> I get "out of memory" complaints from psql when I try your test case.

Hum, strange.

It's a normal 32bit Intel Debian system, nothing much special done
to increase the kernel/user split or anything like that as far as I
remember on this box.  If I try with larger sizes it falls over with
"out of memory", but up until around 755MB (760MB fails) it gives back
"INSERT 0 1" which I've always read as inserting a row.  A select on the
table gives this inserted row containing a zero length string.


  Sam