Re: postgres catalog files problem

"Josh Harrison" <joshques(at)gmail(dot)com> writes:
> Yes...there is a relation in pg_class with the name 'payment' but its oid is
> not 672178. So why is it giving me "could not open relation with OID 672178"
> when i try an update statement ?

Well, are there any other relations that the UPDATE might need to touch?
(Think about foreign keys, or even just indexes.)

> I use version 8.2. I think the problem started when i manually deleted some
> rows from the pg_class catalog file instead of using 'drop table' sql
> command. Do you think this created the problem?

Egad. That is *definitely* in the category of "don't do that if you're
not damn sure of what you're doing".

regards, tom lane