Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.3/8.11.1) with SMTP id f2L4UKH60902
	for <pgsql-interfaces@postgresql.org>;
	Tue, 20 Mar 2001 23:30:20 -0500 (EST)
	(envelope-from pgsql-interfaces-owner@postgresql.org)
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 f2JJlnN19300
	for <pgsql-interfaces@postgresql.org>;
	Mon, 19 Mar 2001 14:47:49 -0500 (EST)
	(envelope-from mike@cyborg-group.com)
Received: from [192.168.10.125] (helo=[192.168.10.125])
	by mail1.mailshot with esmtp (Exim 3.15 #1 (Debian))
	id 14f47H-0007Lh-00
	for <pgsql-interfaces@postgresql.org>; Mon, 19 Mar 2001 18:10:51 +0000
Subject: major problem with update
From: mike <mike@cyborg-group.com>
To: pgsql-interfaces@postgresql.org
In-Reply-To: <3A3F7BCF.D2645F7F@link.com>
Content-Type: text/plain
X-Mailer: Evolution (0.9/+cvs.2001.03.07.09.05 - Preview Release)
Date: 19 Mar 2001 19:52:16 +0000
Mime-Version: 1.0
Message-Id: <E14f47H-0007Lh-00@mail1.mailshot>
X-Archive-Number: 200103/157
X-Sequence-Number: 1318

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