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
onlyabout 10000 records