Using version 7.0.2 (system is production, so I can't take it down for
minor releases) I enter:
$ pg_dump romanlegion > rdb.backup
and I get:
failed sanity check, table usergames was not found
Ok, fair enough, so:
$ psql romanlegion
romanlegion=# \d usergames
Table "usergames"
Attribute | Type | Modifier
------------+---------+----------
gameuserid | integer | not null
gameplayed | integer | not null
Index: unique_played
romanlegion=# select * from usergames ;
gameuserid | gameplayed
------------+------------
10 | 1
<snip>
442 | 10
(477 rows)
romanlegion=#
Now, it can find the table, describe the table, select from the table,
and the more complex queries I do on the site work just fine also. I
can make sure it is where I expect it to be.
$ su postgres
Password:
$ ls /var/lib/pgsql/data/base/romanlegion/usergames -al
-rw------- 1 postgres postgres 40960 Jan 25 23:43
/var/lib/pgsql/data/base/romanlegion/usergames
So now I'm out of ideas. Is there some known bug? Or is this just
being weird?