X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3F59A14B281C for ; Wed, 11 Aug 2004 19:48:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96660-09 for ; Wed, 11 Aug 2004 22:48:49 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 93D2514B2806 for ; Wed, 11 Aug 2004 19:48:47 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i7BMmlmv020892; Wed, 11 Aug 2004 18:48:47 -0400 (EDT) To: Thomas Seeber Cc: PostgreSQL Subject: Re: Wierd Error on update In-reply-to: <578aa3f7040811132151bb6f41@mail.gmail.com> References: <578aa3f7040811132151bb6f41@mail.gmail.com> Comments: In-reply-to Thomas Seeber message dated "Wed, 11 Aug 2004 15:21:09 -0500" Date: Wed, 11 Aug 2004 18:48:46 -0400 Message-ID: <20891.1092264526@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/100 X-Sequence-Number: 18597 Thomas Seeber writes: > I am running Postgres 7.3 on a intel Linux Redhat 7.3 base. Original 7.3 release, or (I hope) 7.3.something? > I am getting two errors which are a bit confounding. > ERROR: pg_class_aclcheck:relation 474653086 not found Are there any views involved? Is the statement invoking any functions? How about triggers? Foreign keys? Rules? Also, is it always the same number in the error, or does that change from run to run? The problem looks a bit like a corrupted rule or view, but I'm not entirely sure how one would get involved in a simple UPDATE. regards, tom lane