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. -- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
