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