"Josh Harrison" <joshques@gmail.com> writes:
> When i try to give this query
> UPDATE payment
> SET desc='New description'
> WHERE payment_id='xyz'
> I got the error
> ERROR: could not open relation with OID 672178
Hmm, there apparently *is* a pg_class row for relation 'payment', else
you'd not get this far, and I'll bet it's got OID 672178 --- try "select
oid from pg_class where relname = 'payment'" to see. If so, it seems
likely that this is just an index corruption and you can get out of it
by REINDEXing pg_class_oid_index. Depending on what PG version you are
using, that may require special setup --- read the REINDEX reference
page *for your version* before proceeding.
What version is it, anyway, and what were you doing before you got this
error the first time? This isn't exactly an everyday type of problem.
regards, tom lane