Thread: Re: major problem with update

Re: major problem with update

From
mike
Date:
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