"Josh Harrison" <joshques@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
