Re: major problem with update - Mailing list pgsql-interfaces

From mike
Subject Re: major problem with update
Date
Msg-id E14f4A9-0007Lm-00@mail1.mailshot
Whole thread Raw
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 abnormally
before or while processing the request.The connection to the server was lost. Attempting reset: Succeeded.The table is
onlyabout 10000 records
 



pgsql-interfaces by date:

Previous
From: Marko Kreen
Date:
Subject: Re: org.postgresql.Driver.java compile problem
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Re: org.postgresql.Driver.java compile problem