On 18 June 2010 17:00, Tom Lane <t...@sss.pgh.pa.us> wrote: > Andy Dale <andy.d...@gmail.com> 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.
