Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4UEe6E05585 for ; Wed, 30 May 2001 10:40:06 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.3/8.11.3) with ESMTP id f4UEdYR21604; Wed, 30 May 2001 10:39:34 -0400 (EDT) To: =?iso-8859-1?Q?DI_Hasen=F6hrl?= cc: pgsql-sql@postgresql.org Subject: Re: ERROR: Class '37632' not found In-reply-to: <000f01c0e90e$66ed1000$01011eac@irina> References: <000f01c0e90e$66ed1000$01011eac@irina> Comments: In-reply-to =?iso-8859-1?Q?DI_Hasen=F6hrl?= message dated "Wed, 30 May 2001 15:42:42 +0200" Date: Wed, 30 May 2001 10:39:34 -0400 Message-ID: <21601.991233574@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200105/330 X-Sequence-Number: 3171 =?iso-8859-1?Q?DI_Hasen=F6hrl?= writes: > When I want to create a rule *r_name*, I get the message, that this rule st= > ill exists and when I want to drop my rule *r_name*, I get the message: Cla= > ss '37632' not found Curious. That seems to indicate that the table the old rule is for has been deleted ... but why is the rule still there? It should've been deleted too. What version of Postgres is this? Do you recall exactly what you did with the old table? You might be able to get back into a consistent state by manually removing the rule entry (delete from pg_rewrite where rulename = 'foo') but I'm hesitant to recommend that when we don't know how you got into this state in the first place. regards, tom lane