Re: Problem with oids for table names getting out of sync?

Omar Eljumaily <omar2@omnicode.com> writes:
> I've run into this sort of obscure problem.  I'm using libpq with a
> front end database api where I need to track column names and how
> they're returned in libpq queries.  What's happening is that I start out
> with a set of table names when I open my database with a query:

> SELECT relfilenode, relname FROM pg_class WHERE relname !~ '^(pg_|sql_)'
> AND relkind = 'r'

> But these don't agree with the oids when I subsequently fetch my rows
> and use the following:

>             Oid o = PQftable(_res, i);

Um ... are you laboring under some delusion about relfilenode being the
same as relation OID?

            regards, tom lane