query failing with out of memory error message.

From: "Joe Maldonado" <jmaldonado(at)webehosting(dot)biz>
To: pgsql-general(at)postgresql(dot)org
Subject: query failing with out of memory error message.
Date: 2004-06-29 18:01:51
Message-ID: opsada1dmo9utx1k@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,
I have a seemingly corrupt row in a table and wanted to look at it's
contents.
when I try to query it I get the following...

db=# select * from some_table offset 411069 limit 1;
ERROR: invalid memory alloc request size 4294967293

but when I select individual fields within the record I get data.

Is there a way to read this row from the datafile to examine it closer?

--
Joe Maldonado
jmaldonado(at)webehosting(dot)biz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Franco Bruno Borghesi 2004-06-29 20:21:20 Re:
Previous Message CSN 2004-06-29 17:23:25 Re: dup(0) failed after 3195 successes: Bad file descriptor