On 18 June 2010 17:00, Tom Lane <[email protected]> wrote: > Andy Dale <[email protected]> writes: > >> Try: > >> SELECT oid,* from pg_database ; > >> > >> I suspect the relfilnode you are looking at is another database in the > >> cluster. > > > Maybe I am possibly doing that. > > There isn't any "maybe" involved here. Follow Adrian's advice and > determine for sure exactly which database that subdirectory represents. > The subdirectory name will match the OID in the pg_database row. > > It's possible for the same table OID to be in use in more than one > database, so the fact that you got a match to the other table doesn't > in itself prove you're looking at the right database. > > regards, tom lane >
OK, I have just run the query, and both are in the same database.
