Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 45B5E475A7F for ; Fri, 8 Mar 2002 15:05:12 -0500 (EST) 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 g28K56S21092; Fri, 8 Mar 2002 15:05:06 -0500 (EST) To: "Zhang, Anna" Cc: "'pgsql-admin@postgresql.org'" Subject: Re: vacuum error In-reply-to: <5511D658682A7740BA295CCF1E1233A635A868@vsvapostal2.bkup3> References: <5511D658682A7740BA295CCF1E1233A635A868@vsvapostal2.bkup3> Comments: In-reply-to "Zhang, Anna" message dated "Fri, 08 Mar 2002 11:36:42 -0500" Date: Fri, 08 Mar 2002 15:05:05 -0500 Message-ID: <21089.1015617905@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200203/110 X-Sequence-Number: 3644 "Zhang, Anna" writes: > ERROR: RelationBuildTriggers: 2 record(s) not found for rel domain. > I deleted triggers that referenced domain before vacuum, is this the cause? If you deleted them via "delete from pg_trigger" and not by DROP TRIGGER, then yes. You'll need to manually fix the value of pg_class.reltriggers for that table. regards, tom lane