Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id DFE53475B2C for ; Fri, 8 Mar 2002 13:02:19 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 5B871D5F7; Fri, 8 Mar 2002 10:02:19 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 4CF7D5BFC; Fri, 8 Mar 2002 10:02:19 -0800 (PST) Date: Fri, 8 Mar 2002 10:02:19 -0800 (PST) From: Stephan Szabo To: "Zhang, Anna" Cc: "'pgsql-admin@postgresql.org'" Subject: Re: vacuum error In-Reply-To: <5511D658682A7740BA295CCF1E1233A635A868@vsvapostal2.bkup3> Message-ID: <20020308095922.W2137-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/107 X-Sequence-Number: 3641 On Fri, 8 Mar 2002, Zhang, Anna wrote: > Hi, > I got an error when vacuum database, see below: > > $vacuumdb xdap > ERROR: RelationBuildTriggers: 2 record(s) not found for rel domain. > > I deleted triggers that referenced domain before vacuum, is this the cause? > How can I fix it? or It doesn't bother, It's ok to ignore such error? It will be a problem. Update the pg_class row associated with domain to fix the value of reltriggers, something like: update pg_class set reltriggers=(select count(*) from pg_trigger where tgrelid=pg_class.oid) where relname='domain';