pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: Class '37632' not found
2+ messages / 2 participants
[nested] [flat]
* ERROR: Class '37632' not found
@ 2001-05-30 13:42 DI Hasenöhrl <i.hasenoehrl@aon.at>
2001-05-30 14:39 ` Re: ERROR: Class '37632' not found Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: DI Hasenöhrl @ 2001-05-30 13:42 UTC (permalink / raw)
To: pgsql-sql
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 still exists and when I want to drop my rule *r_name*, I get the message: Class '37632' not found
Please, can anyone help me to solve this problem.
Thanks in advance
Irina
E-Mail: i.hasenoehrl@aon.at
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ERROR: Class '37632' not found
2001-05-30 13:42 ERROR: Class '37632' not found DI Hasenöhrl <i.hasenoehrl@aon.at>
@ 2001-05-30 14:39 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2001-05-30 14:39 UTC (permalink / raw)
To: DI Hasenöhrl <i.hasenoehrl@aon.at>; +Cc: pgsql-sql
=?iso-8859-1?Q?DI_Hasen=F6hrl?= <i.hasenoehrl@aon.at> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-05-30 14:39 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-30 13:42 ERROR: Class '37632' not found DI Hasenöhrl <i.hasenoehrl@aon.at>
2001-05-30 14:39 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox