On Mon, Nov 24, 2008 at 09:06:14AM -0500, Tom Lane wrote: > Sam Mason <sam@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
