Received: from mail1.mailshot (mailgate.cyborg-group.com [62.49.135.2] (may be
	forged))
	by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2JJocN19866
	for <pgsql-interfaces@postgresql.org>;
	Mon, 19 Mar 2001 14:50:38 -0500 (EST)
	(envelope-from mike@redtux.demon.co.uk)
Received: from [192.168.10.125] (helo=[192.168.10.125])
	by mail1.mailshot with esmtp (Exim 3.15 #1 (Debian))
	id 14f4A9-0007Lm-00
	for <pgsql-interfaces@postgresql.org>; Mon, 19 Mar 2001 18:13:49 +0000
Subject: Re: major problem with update
From: mike <mike@redtux.demon.co.uk>
To: pgsql-interfaces@postgresql.org
Content-Type: text/plain
X-Mailer: Evolution (0.9/+cvs.2001.03.07.09.05 - Preview Release)
Date: 19 Mar 2001 19:55:15 +0000
Mime-Version: 1.0
Message-Id: <E14f4A9-0007Lm-00@mail1.mailshot>
X-Archive-Number: 200103/143
X-Sequence-Number: 1304

Can anyone one explain why this is happening. 

All I am trying to do is to convert a text field to a date

and postgres is bombing out (using 7.03)
 
update imp4 set f100=to_date(f3,'dd-mm-yy');
FATAL 1:  Memory exhausted in AllocSetAlloc()
pqReadData() -- backend closed the channel unexpectedly.
       This probably means the backend terminated abnormally
       before or while processing the request.
 The connection to the server was lost. Attempting reset: Succeeded.
 
 The table is only about 10000 records