pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
major problem with update
2+ messages / 2 participants
[nested] [flat]

* major problem with update
@ 2001-03-19 19:52 mike <mike@cyborg-group.com>
  0 siblings, 0 replies; 2+ messages in thread

From: mike @ 2001-03-19 19:52 UTC (permalink / raw)
  To: 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 only about 10000 records




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: major problem with update
@ 2001-03-19 19:55 mike <mike@redtux.demon.co.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: mike @ 2001-03-19 19:55 UTC (permalink / raw)
  To: 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 only about 10000 records




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-03-19 19:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-19 19:52 major problem with update mike <mike@cyborg-group.com>
2001-03-19 19:55 Re: major problem with update mike <mike@redtux.demon.co.uk>

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