Thread

clarifications needed on postgres/perl

Srishti Software Pvt. Ltd. <srishti@giasbg01.vsnl.net.in> — 1999-09-28T07:40:40Z

Hi!,
we are using postgresql(6.3.2-10) on red-hat linux 5.2.
we use perl-5 to access postgres.
the problem we have is :
we have a table having 13 fields, now when updating one of the fields
from the perl program, for more than 800 records, the following error is

reported :
    "FATAL 1: palloc failed: memory exhausted."
how ever when doing the same directly in psql monitor, there is no
error. also when the number of records to be updated are below 800 there

is no error.
kindly suggest some remidies,
we will be very thankful.

looking forward to ur valuable suggestions very soon,
with best regards,
Team srishti.