Hi,
I'm building an application that needs to internally store a table ID for
each of the tables that have been loaded into it. I found that the pg_class
catalog table contains the oid column that is an unique identifier for each
table. NOTICE that I'm not talking about the oid metacolumn that can be used
optionally in any custom table as a replacement of a primary key; here it's
just a fixed table identifier that we need.
The question is, it appears that the table oids after some time, are changed
internally and the old values do not match anymore with the current ones.
The application needs the actual oids as it has to run a Postgres plugin
where internally checks for the table id to make sure it is handling a table
loaded into the application.
What kind of events can trigger the oid change? Is there any other internal
ID that can be used for this purpose?
Thanks,
Valerio
--
View this message in context: http://www.postgresql-archive.org/Table-OIDs-are-fixed-values-tp5960746.html
Sent from the PostgreSQL - pgadmin hackers mailing list archive at Nabble.com.