andrea suisani <[EMAIL PROTECTED]> writes: > pg_dump: ERROR: could not open relation with OID 201327173 > pg_dump: SQL command to dump the contents of table "nominativi" failed: > PQendcopy() failed. > pg_dump: Error message from server: ERROR: could not open relation with OID > 201327173
Hmm ... what do you get from select oid from pg_class where relname = 'nominativi'; select relname from pg_class where oid = 201327173; If the first returns 201327173 while the second doesn't return anything, then I'd wonder about corruption of pg_class's OID index. REINDEXing it might help. I don't remember whether 7.4 makes you use a standalone backend to reindex system catalogs --- see its REINDEX man page for details. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly