Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id E96184759D8 for ; Fri, 21 Jun 2002 00:35:16 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 958DE475C63 for ; Fri, 21 Jun 2002 00:35:12 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g5L4Yq116687; Fri, 21 Jun 2002 00:34:52 -0400 (EDT) To: terry@greatgulfhomes.com Cc: "Postgres (E-mail)" Subject: Re: crash problem In-reply-to: <000001c218c3$18736420$2766f30a@development.greatgulfhomes.com> References: <000001c218c3$18736420$2766f30a@development.greatgulfhomes.com> Comments: In-reply-to terry@greatgulfhomes.com message dated "Thu, 20 Jun 2002 21:29:31 -0400" Date: Fri, 21 Jun 2002 00:34:52 -0400 Message-ID: <16684.1024634092@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200206/29 X-Sequence-Number: 1404 terry@greatgulfhomes.com writes: > My database crashed earlier. It's starts up fine, and I can use it, but I > cannot back it up, it reports this error: > bash$ pg_dump -t letter_tag_execute_types devtest > > bkletter_tag_execute_types > getTables(): SELECT (for TRIGGER) failed. Explanation from backend: 'ERROR: > No > such attribute or function 'tgdeferrable' > '. (1) Are you sure your pg_dump version matches your backend version? (And exactly what version are we discussing here, anyway?) (2) A reindex of pg_attribute might help. See the 7.2 REINDEX man page for a reasonably complete description of how to reindex system catalogs. The 7.1 procedure is the same, but the docs are poorer... regards, tom lane PS: this is pretty far off-topic for pgsql-docs. Please think a little more about where to post before posting.