Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 468902E38F7 for ; Thu, 29 Nov 2007 04:09:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66811-03 for ; Thu, 29 Nov 2007 04:09:54 -0400 (AST) Received: from out1.smtp.messagingengine.com (out1.smtp.messagingengine.com [66.111.4.25]) by postgresql.org (Postfix) with ESMTP id C7AA42E38F3 for ; Thu, 29 Nov 2007 04:09:54 -0400 (AST) Received: from compute1.internal (compute1.internal [10.202.2.41]) by out1.messagingengine.com (Postfix) with ESMTP id 82976578EC for ; Thu, 29 Nov 2007 03:09:53 -0500 (EST) Received: from heartbeat1.messagingengine.com ([10.202.2.160]) by compute1.internal (MEProxy); Thu, 29 Nov 2007 03:09:53 -0500 X-Sasl-enc: iopNAu0yHW2UjfhGtcuWwucPh8PJPlCkkNPIQuJm1GsE 1196323793 Received: from [192.168.1.235] (64-142-85-108.dsl.dynamic.sonic.net [64.142.85.108]) by mail.messagingengine.com (Postfix) with ESMTP id 1574D323B for ; Thu, 29 Nov 2007 03:09:52 -0500 (EST) Message-ID: <474E7327.1010805@fastmail.net> Date: Thu, 29 Nov 2007 00:07:03 -0800 From: Darren Reed User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Why dos select work when pg_dump fails? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/239 X-Sequence-Number: 27482 For whatever reason, I'm back dealing with corrupted tables but curiously while this fails: pg_dump -U postgres -a -t table -f /data/table.dump this works: psql -U postgres -A -o /data/table.dump -c "SELECT * FROM table;" Graned the format of the data is different, but regardless, the data is still there. The message from pg_dump when it fails is: pg_dump: SQL command failed pg_dump: Error message from server: ERROR: out of memory DETAIL: Failed on request of size 20. pg_dump: The command was: SELECT t.tableoid, t.oid, t.relname as indexname, pg_catalog.pg_get_indexdef(i.indexrelid) as indexdef, t.relnatts as indnkeys, i.indkey, i.indisclustered, c.contype, c.conname, c.tableoid as contableoid, c.oid as conoid, (SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) as tablespace FROM pg_catalog.pg_index i JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) LEFT JOIN pg_catalog.pg_depend d ON (d.classid = t.tableoid AND d.objid = t.oid AND d.deptype = 'i') LEFT JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE i.indrelid = '16456'::pg_catalog.oid ORDER BY indexname Darren