Omar Eljumaily <omar2(at)omnicode(dot)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