From: mike <mike@redtux.demon.co.uk>
To: pgsql-interfaces@postgresql.org
Subject: Re: major problem with update
Date: 19 Mar 2001 19:55:15 +0000
Message-ID: <E14f4A9-0007Lm-00@mail1.mailshot> (raw)
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 only about 10000 records
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mike@redtux.demon.co.uk
Subject: Re: major problem with update
In-Reply-To: <E14f4A9-0007Lm-00@mail1.mailshot>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox