Hello list, I have contributed the mysql2pgsql script to the community at http://pgfoundry.org/projects/mysql2pgsql/ I am wondering why I pg_class can see it, but " AND pg_catalog.pg_table_is_visible(c.oid)" (as in \d korean_english) queries are returning false. My database has been acting strangely since copying files from backup, including having to use pg_resetxlog for transactions). What went wrong is ??? but most importantly, I want to access that table as that holds lots of work. I also ran [postgres@localhost ~]$ pg_filedump mod/base/16388/4273964 > 4273964.out [postgres@localhost ~]$ cat 4273964.out | grep ERROR [postgres@localhost ~]$ ls -lah *.out -rw-r--r-- 1 postgres postgres 13M 2008-09-08 20:58 4273964.out on the table but can't spot any irregularities. where should I look? how can I get to the data ??? apparently, it's not corrupt? (NOTE: also has happened similar messages from some other tables which I dropped) ================details ========================== I am getting mod=# \d korean_english ; ERROR: cache lookup failed for relation 4273964 and cannot run \dt anymore on this database, nor dump it (dumping gives ..... another error, ((((((((((((((((((((((( ERROR: relation "modpgwebuser.korean_english" does not exist pg_dump: SQL command failed pg_dump: Error message from server: ERROR: relation "modpgwebuser.korean_english" does not exist pg_dump: The command was: LOCK TABLE modpgwebuser.korean_english IN ACCESS SHARE MODE )))))))))))))))))) I assume I look like this for 4273964 .... mod=# select relname,relnamespace,relfilenode,relpages,reltuples from pg_class where relfilenode= 4273964 ; relname | relnamespace | relfilenode | relpages | reltuples ----------------+--------------+-------------+----------+----------- korean_english | 16394 | 4273964 | 2689 | 188763 (1 row) That is the correct # of tuples for the (unaccessable) table. I searched through the main list of pg_catalog tables on www.postgresql.org but I am not using oid's and it's the relfilenode which matches, is that correct? This error came after I restored from backup copy. I "pg_ctl -D mod stop" my database and then copy the files using the commandline to a backup directory, and when I restored a backup from last time, now I get these error messages.... I am not using slony, not restoring a backup from a different version, perhaps (I amonly human, but this is unlikely, but needs to be pondered ) perhaps made a backup without shutting down the backend (???? could i be that stupid??). Also, prior to this I was deleting rows using a php script which was acting strangely by not outputting results to the browser, but after the statement ran, was prompting me to download the file 'index.php' which upon opening was empty (? can that be related ?). I also have ran [postgres@localhost ~]$ /usr/local/pg8.1/bin/pg_resetxlog -x 0x5000000 -l 0x1,0x0,0xC9 mod on the database because of the following error, which was taken care of by the above. ERROR: cache lookup failed for relation 1690989 ERROR: cache lookup failed for relation 1690989 mod=# ERROR: xlog flush request 0/B9F9919C is not satisfied --- flushed only to 0/9E8BCFA4 CONTEXT: writing block 45 of relation 1663/16388/1249 I tried to find dependencies and what-not by the following queries, but came out empty-handed. mod=# select * from pg_depend where refobjid=4273964 ; classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype ---------+-------+----------+------------+----------+-------------+--------- (0 rows) mod=# select * from pg_depend where objid=4273964 ; classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype ---------+-------+----------+------------+----------+-------------+--------- (0 rows) mod=# select * from pg_depend where refobjid=4273964 ; classid | objid | objsubid | refclassid | refobjid | refobjsubid | deptype ---------+-------+----------+------------+----------+-------------+--------- (0 rows) mod=# select * from pg_trigger where tgconstrrelid=4273964 ; tgrelid | tgname | tgfoid | tgtype | tgenabled | tgisconstraint | tgconstrname | tgconstrrelid | tgdeferrable | tginitdeferred | tgnargs | tgattr | tgargs ---------+--------+--------+--------+-----------+----------------+--------------+---------------+--------------+----------------+---------+--------+-------- (0 rows) mod=# select * from pg_index where indexrelid=4273964 ; indexrelid | indrelid | indnatts | indisunique | indisprimary | indisclustered | indkey | indclass | indexprs | indpred ------------+----------+----------+-------------+--------------+----------------+--------+----------+----------+--------- (0 rows) Thank you, Joseph.
