major problem with update - Mailing list pgsql-interfaces

From mike
Subject major problem with update
Date
Msg-id E14f47H-0007Lh-00@mail1.mailshot
Whole thread Raw
In response to Perl & Postgres  ("Jimi Thompson" <jthompson@link.com>)
List pgsql-interfaces
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 abnormallybefore or
whileprocessing the request.
 
The connection to the server was lost. Attempting reset: Succeeded.

The table is only about 10000 records



pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: triggered data change violation
Next
From: Silky Mittal
Date:
Subject: problem compiling the jdbc driver