On 18 June 2010 17:00, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Andy Dale <andy.dale@xxxxxxxxx> 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.
