Re: Problem with oids for table names getting out of sync? - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with oids for table names getting out of sync?
Date
Msg-id 18930.1175749819@sss.pgh.pa.us
Whole thread Raw
In response to Problem with oids for table names getting out of sync?  (Omar Eljumaily <omar2@omnicode.com>)
Responses Re: Problem with oids for table names getting out of sync?  (omar <omar2@omnicode.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Using MS Access front-end with PG]
Next
From: "Postgres User"
Date:
Subject: Granting permissions