"Oliver Elphick" <olly@lfix.co.uk> writes:
>>> However, I cannot find relation 124171; is there any way to find out
>>> where a relation is, given only its oid?
>>
>> This might give you a pretty good hint...
>>
>> select * from pg_attribute where attrelid = 124171;
Actually, "select * from pg_class where oid = 124171" is the canonical
answer; if that doesn't produce anything, you have no such table.
> I tried looking for the oid in every system table listed by \dS - no joy :-(
Is it possible that you dropped the table in question since that try?
If you recreated it, it wouldn't have the same OID the second time.
Another possibility is that the rule dumper is picking up a completely
wrong number for some reason. I thought that code was pretty solid by
now, but it might still have some glitches left.
If you provided an SQL script that reproduces the problem, more people
might be motivated to look for it...
regards, tom lane