From i.hasenoehrl@aon.at Wed May 30 13:42:10 2001 Received: from email01.aon.at (WARSL401PIP1.highway.telekom.at [195.3.96.69]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4UDgAE79145 for ; Wed, 30 May 2001 09:42:10 -0400 (EDT) (envelope-from i.hasenoehrl@aon.at) Received: (qmail 253968 invoked from network); 30 May 2001 13:42:04 -0000 Received: from n649p012.adsl.highway.telekom.at (HELO irina) ([62.47.25.12]) (envelope-sender ) by qmail1.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 30 May 2001 13:42:04 -0000 Message-ID: <000f01c0e90e$66ed1000$01011eac@irina> From: =?iso-8859-1?Q?DI_Hasen=F6hrl?= To: Subject: ERROR: Class '37632' not found Date: Wed, 30 May 2001 15:42:42 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01C0E91F.2A21F3A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200105/328 X-Sequence-Number: 3169 This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C0E91F.2A21F3A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have a problem to drop a rule from my database. 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 Please, can anyone help me to solve this problem. Thanks in advance Irina E-Mail: i.hasenoehrl@aon.at ------=_NextPart_000_000C_01C0E91F.2A21F3A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
I have a problem to drop a rule from my=20 database.
 
When I want to create a rule *r_name*, I g= et the=20 message, that this rule still exists and when I want to drop my rule *r_nam= e*, I=20 get the message: Class '37632' not found
 
Please, can anyone help me to solve this= =20 problem.
Thanks in advance
 
Irina
E-Mail: i.hasenoehrl@aon.at
------=_NextPart_000_000C_01C0E91F.2A21F3A0-- From tgl@sss.pgh.pa.us Wed May 30 14:40:06 2001 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