Re: Unable to determine what has a particular OID

On 18 June 2010 17:00, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Andy Dale <andy(dot)dale(at)gmail(dot)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.